Excel Pet Peeves

Water Cooler
#1

Does anyone else have Excel pet peeves? I hate when I open someone elses work and the columns widths don’t allow to see some words, or there are number columns and there are some large numbers so you get the ####. Alt+H+O+I, damn.

#2

I hate that you can’t have two work books open at the same time. You have to jailbreak excel and only works if you have two or more screens.

#3

I wish I had your problem. (edit–directed at Ramos)

#4

You have to open a second workbook by clicking on OFFICE - EXCEL. It’ll work. If you try to do this opening the two Excel files it won’t work.

I hate when the font/size is not Arial 10.

#5

I’m assuming you mean side-by-side for linking/etc…in which case I 100% agree. If only you could maximize Excel to both screens and have a workbook in each.

Biggest peeve: F1. The number of times I’ve bumped that button when aiming for F2 or Esc…

Also, dealing with other peoples hideous models. One guy on my team uses pretty much every color on the palette and makes a thousand tabs. Or when they do vlookup’s with column & row specified ranges, rather than just columns (A:A etc). I finally got everyone using named ranges though, so we’re seeing progress.

#6

That’s just one of many…I also hate when there should be formulas for all values but theres one random line of something that someone decided to hard code in and so when you’re updating some source data, you have those few cells that don’t update…some ppl just don’t make sense sometimes.

#7

I hate watching nuggas using the mouse. CTRL+SHIFT+P to Format Cells Brah. Don’t be clicking and sht.

#8

Ever try going to View > Window > New Window? (It’s right next to “Freeze Panes” in 2013 Excel.) This opens up an identical window so you can reference other tabs. This is an absolutely essential feature if you’re working in multiple tabs.

#9

I can’t stand that there aren’t any hotkeys to change the decimal place… Unless I’m just missing something?

#10

Arial Narrow?

#11

Holy guacamole, that works. That’s actually a really big help.

I love you. (totally homo)

#12

Whoa, thanks bro!

#13

MENU + F

#14

Or you could just pin the Excel shortcut to your taskbar or desktop. Then all you have to do is click on it again and a new window opens.

(I’m using Windows 7, by the way. Don’t know about Windows 8 or Vista or XP.)

#15

Kinda an Excel gripe, but when I was younger and interviewing, negros would be all like, “Do you know how to do Pivot Tables and V-Lookups?” I had to sheepishly say no as my hacksaw undergrad didn’t teach such things.

Knowing what I know now, both of those functions can be learned inside of a lunch break. Excel ain’t rocket science…stupid.

#16

I’m biting my tongue so hard it’s starting to bleed.

#17

^ Why.

#18

Yea. It’s really true. I don’t know why people put so much emphasis on this like it’s a skill. These are very basic functions in excel. If you’re asking someone if they know the index function I think that is more advanced, but to create a vlookup, set up a filter or use a pivot table is easy.

#19

I’ve learend over the years that people who say they know how to use Excel, really don’t know how to use Excel.

#20

Yup, that’s exactly what I do. I stretch out Excel across my two montiors and can have two different workbooks open at the same time.