Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I print lines in a blank workbook?
I need to print a blank workbook that looks exactly like it looks on the
screen but when I print it , it will not print the lines, the only thing it prints is the headings I entered. Can someone explain how to do this please? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I print lines in a blank workbook?
Do search in help - "Print gridlines in a worksheet" - follow instructions
or you may just need to insert borders. In 2007 you'll find this on the ribbon in Home tab - font "Carla Missouri" wrote: I need to print a blank workbook that looks exactly like it looks on the screen but when I print it , it will not print the lines, the only thing it prints is the headings I entered. Can someone explain how to do this please? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I print lines in a blank workbook?
Try setting the Print Area to include the entire area you want to print
otherwise Excel only prints the cells containing data. If you don't know how then lookup Set Print Area in help. -- Regards, OssieMac "Arceedee" wrote: Do search in help - "Print gridlines in a worksheet" - follow instructions or you may just need to insert borders. In 2007 you'll find this on the ribbon in Home tab - font "Carla Missouri" wrote: I need to print a blank workbook that looks exactly like it looks on the screen but when I print it , it will not print the lines, the only thing it prints is the headings I entered. Can someone explain how to do this please? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I print lines in a blank workbook?
If you're just trying to print a form, you can go to the bottom right cell
you want printed and type a space (spacebar). Or you can type ="" so you can see something's there in the formula bar later. I'm assuming gridlines are turned on in Page Setup. "Carla Missouri" wrote: I need to print a blank workbook that looks exactly like it looks on the screen but when I print it , it will not print the lines, the only thing it prints is the headings I entered. Can someone explain how to do this please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove extra blank lines in a column when I print? | Excel Discussion (Misc queries) | |||
Macro not recognizing blank lines as blank | Excel Discussion (Misc queries) | |||
Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
how do I print grid lines for blank rows | Excel Discussion (Misc queries) | |||
how do I print grid lines for blank rows | Excel Discussion (Misc queries) |