Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default In Excel, how do I print the cell blocks as well as the data?

I am preparing a spread sheet with excel and when I print it only the data
prints. I would like the cell blocks also printed. How do I get this to
happen? I have tried highlighting the whole page but it still prints only
the data.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default In Excel, how do I print the cell blocks as well as the data?

In the Page Setup dialog box, go to the Sheet tab and select Gridlines under
Print.

"aa3kt" wrote:

I am preparing a spread sheet with excel and when I print it only the data
prints. I would like the cell blocks also printed. How do I get this to
happen? I have tried highlighting the whole page but it still prints only
the data.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 84
Default In Excel, how do I print the cell blocks as well as the data?

On 4/29/2010 9:07 AM, aa3kt wrote:
I am preparing a spread sheet with excel and when I print it only the data
prints. I would like the cell blocks also printed. How do I get this to
happen? I have tried highlighting the whole page but it still prints only
the data.


On the page layout tab in Excel 2007, check the print option under
Gridlines.

If using Excel 2003, look for "print gridlines" in Excel help.

Bill
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL hangs when deleting large blocks of data Oxo Excel Discussion (Misc queries) 3 April 22nd 23 12:12 PM
Sort blocks of data bushwood Excel Discussion (Misc queries) 1 April 16th 10 12:57 PM
averaging particular blocks of data robert111 Excel Discussion (Misc queries) 6 July 12th 06 02:41 PM
print in blocks in excel david Excel Discussion (Misc queries) 1 May 3rd 05 09:46 PM
Moving blocks of data in excel Yasmin Excel Discussion (Misc queries) 1 March 17th 05 10:39 PM


All times are GMT +1. The time now is 11:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"