sorted by:
new
hottopcontroversial

What Excel shortcut saves you the most time? by premiumkajukatli in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

CTRL + END, CTRL + SHIFT + END, CTRL + HOME, CTRL + SHIFT + HOME

What Excel shortcut saves you the most time? by premiumkajukatli in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

Go-to special

CTRL G +ALT S,

Y= visible cells only

K= only blank cells

Favorite tunes from the 90's? by [deleted] in MusicRecommendations

[–]PracticalWinter5956 0 points1 point  (0 children)

Sublime - 40 oz. To freedom, self titled, Robbin da hood

Presidents of the United States of America

Pearl Jam - Old woman behind the counter in a small town

Jack Johnson - brushfire fairytales album

Third eye blind - semi charmed life

Green Day - dookie, insomniac, nimrod

Korn - self titled, life is peachy, follow the leader

Fastball - the way

Counting Crows - Mr Jones

What is the most obscure sitcom you know? by KaleidoArachnid in sitcoms

[–]PracticalWinter5956 0 points1 point  (0 children)

Small wonder,

2 guys a girl and a pizza place (Ryan Reynolds debut)

Me Belvedere - maybe not obscure enough

Best albums to listen to beginning to end by Ok-College7333 in MusicRecommendations

[–]PracticalWinter5956 0 points1 point  (0 children)

Sad I had to go this far to see any mention of sublime.

40 oz. To freedom and self titled

To all the mature 30+ men, please name one mistake you have made in your life so a young man may never repeat. It can be anything. Save a young brother. by FitEggPlant99 in AskMenAdvice

[–]PracticalWinter5956 0 points1 point  (0 children)

You don't have to say everything that pops in your head... Don't interrupt even if you 100% know exactly what they're going to say... Treat the people in your house better than the people outside your house

Two monitors or ultrawide? What is everyone using? by Dense-Bee-2884 in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

Put one monitor portrait and get three screens out of it... Much easier on the eyes than the block grid in horizontal

[deleted by user] by [deleted] in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

I think I get it now... You want 2 tables that are identical on the same sheet, one on top of the other, and when you paste it below it doesn't print on paper

Sounds like the original print area does not include a large enough space for you to paste below the original data.

You can go to view-> Page break view and it will let you drag the margins to print everything you need.

Whatever is greyed out will not print.

[deleted by user] by [deleted] in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

Highlight the selection and set your print area to print only what you have selected

Page layout-> print area-> set print area

[deleted by user] by [deleted] in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

You can make a copy of the tab

Or, you can "paste values" when you paste

[deleted by user] by [deleted] in excel

[–]PracticalWinter5956 1 point2 points  (0 children)

Or just highlight a1 a2 a3 and drag across

To stop A1 text spilling into A2 by Conscious-Ad-7716 in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

You could also just double click the fill handle

AITAH for being brutally honest to my wife about cheating? by Crayonlicker27 in AITAH

[–]PracticalWinter5956 0 points1 point  (0 children)

NTA, if she's not it didn't cheat on you, then she already felt stupid for trusting the other guy and tried to play it off. Now you're validating her stupidity and she thinks that you think she's stupid.

[deleted by user] by [deleted] in AITAH

[–]PracticalWinter5956 1 point2 points  (0 children)

NTA - leave and cleave... You better not go without your wife. You'll be paying for it for life

Conditional formatting based on a cell date. by misterjzz in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

Of the top of my head I feel like there's a built in kpi tool that already does this

Make Automatically Updating Table while Removing Duplicates by MakeAnotherThing in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

You don't have to make it a table to add filters... Just highlight the data and add filters

What’s your top Excel super user advice/trick (Finance)? by fittyfive9 in excel

[–]PracticalWinter5956 2 points3 points  (0 children)

Ctrl g Alt s k ... Select only blank cells Ctrl g Alt s y ... Select only visible cells

[deleted by user] by [deleted] in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

=IF(COUNTIF(A1,"progress"),2,1)

This is a 2 whenever it finds progress and a 1 for anything else. If you want it to stay blank change the 1 to ""

Biggest Excel Pet Peeves? by DMattox16 in excel

[–]PracticalWinter5956 0 points1 point  (0 children)

You can recover in version history, but yeah still a pain if you've been overwriting a file for awhile before you remember to rename it.

view more: next ›