Saturday, June 10, 2017

How to Hide Gridlines in Excel - Three Ways

Gridlines in Excel are the faint, grey colored lines that appear around cells in a spreadsheet to distinguish them from one another. By default, the gridlines are displayed in worksheets using a color that is set by Excel. You can essentially turn off the gridlines, cover up the gridlines, or change their color in order to hide them.
There are at least three methods you can use to hide the gridlines in Excel.
1. The proper method is to go to View then uncheck the Gridlines box. You can hide gridlines on multiple sheets by selecting all the sheets first, then unchecking the box.

2. Change a cell’s fill color to white or another color. If you apply a fill color to cells on your worksheet, you won't be able to see or print the cell gridlines for those cells.

3. Change the gridline’s color to white. You can change the default Gridline color by going to File > Options > Advanced then scroll down to Display options for this worksheet.

To see how to do each one of these check out the video below.

Borders are not the same as gridlines in Excel

People often confuse borders and gridlines in Excel. Gridlines cannot be customized in the same manner that borders can. If you want to change the width or other attributes of the lines then you need to use a border. Gridlines are always applied to the whole worksheet or workbook, and can't be applied to specific cells or ranges. If you want to apply lines selectively around specific cells or ranges of cells, you should use borders instead of, or in addition to, gridlines.

Let me know if you found this Excel tip helpful!

Sunday, June 4, 2017

Best Excel Spreadsheet Memes - Prepare to Laugh

I've given hundreds of useful Excel tips since I started blogging eight years (!) ago in 2009. But I can't be 100% serious all the time. I've gotta have a little fun from time to time, like when I shared some of the best Excel pranks and practical jokes, not to mention all the sports related templates I produce. And who doesn't love a good joke or meme? So today I thought I'd share the best Excel spreadsheet memes I've collected over the years!

WARNING: Some of these Excel memes might make you literally laugh out loud. You've been warned.

Best Excel Spreadsheet Memes

How'd you know I like Excel? It's not like I write articles or make videos about it...

Yeah, not gonna happen, I'll make my Excel formulas as long as I want to!

Hmmm ok...

I hope not.

Mind = blown.

It's so worth it once you do you learn Excel VBA though.

Gotta have at least one grumpy cat meme.

Ever feel like this?

Me neither. Do people do that? Remove the gird lines by changing the grid lines color to white?

How many have hid non-working formulas before? Admit it if you have!

Haha, not necessarily.

There's always that one co-worker who spends more time formatting then working on the actual information within the Excel sheet.

When writing those super long formulas in Excel....

Drives me crazy.

When can you ever have enough spreadsheets?

I concur Steve!

Which Excel meme is your favorite? Please let me know by commenting below. Or if have a hilarious one that I failed to mention PLEASE send it to me!