How do I hide the gridlines on a spreadsheet that I exported to Excel?

Question

mine27head Author

Level 1

8 points

How do I hide the gridlines on a spreadsheet that I exported to Excel?

I have a mac OS High Sierra, version 10.13.3.

Processor 3.06 GHz Intel core 2 Duo

Memory 4GB 1067 MHz DDR3

The hide / show gridlines buttons on the 'edit" tab do not seem to work on the standard "Numbers" spreadsheets nor on the spreadsheet that I exported to Excel.

Am I missing something fairly basic?

VIN,iMac (21.5-inch Late 2009), OS X Yosemite (10.10.5)

Posted on Apr 5, 2018 7:56 AM

Reply

Answer 1

Top-ranking reply

jaxjason

Level 5

5,063 points

Apr 5, 2018 9:56 AM in response to mine27head

the grid-line option is to show the faint grey lines that always show up on excel sheets. not the formatting borders.

To set that you need to

Select the range you want to change
go to the Home tab
click the border button in the second section over from the left
Select "No Borders" from the options shown

I can only show you the Windows Excel view, but it is almost identical to the OSX version now.

Jason

Reply

Answer 2

mine27head Author

Level 1

8 points

Apr 5, 2018 11:14 AM in response to jaxjason

Many thanks jason,

Using the "borders" tab I was able to remove all the lines including the grid lines. Then it was a simple job to replace the few borders that I actually required.

I appreciate your speedy help.

John Fulwell

Reply

How do I hide the gridlines on a spreadsheet that I exported to Excel?

Similar questions