#1   Report Post  
Posted to microsoft.public.excel.misc
cmh cmh is offline
external usenet poster
 
Posts: 3
Default printing blank cells

I want excel to print a page of blank cells with gridlines -- but I cannot
get it to do this.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default printing blank cells

Good for chess or checker boarding:

1. select some cells
2. File PrintArea Set PrintArea
3. FIle Page Setup... Sheet and then check Gridlines
--
Gary's Student


"cmh" wrote:

I want excel to print a page of blank cells with gridlines -- but I cannot
get it to do this.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default printing blank cells

Select a range that will use up a page (experiment with A1:J52)
With this selected, use File | Print Area | Set print area
Use File | Print preview (good to have this as an icon on the toolbar)
Within Preview use Page Set up; open Sheet tab and specify gridlines to be
printed
Print page
done!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"cmh" wrote in message
...
I want excel to print a page of blank cells with gridlines -- but I cannot
get it to do this.



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
Using COUNTIF to search for existence Epinn Excel Worksheet Functions 31 October 27th 06 04:57 AM
Calculating only non-empty cells... Jay Excel Worksheet Functions 9 September 22nd 06 03:20 AM
Sumif Cells Are Not Blank Powlaz Excel Worksheet Functions 12 March 15th 06 04:40 PM
CONCATENATE problem with blank cells roger_home Excel Discussion (Misc queries) 1 August 17th 05 09:18 PM
Counting blank and filled cells within a range. greg7468 Excel Discussion (Misc queries) 3 June 28th 05 10:41 PM


All times are GMT +1. The time now is 04:38 AM.

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

About Us

"It's about Microsoft Excel"