ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I print lines in a blank workbook? (https://www.excelbanter.com/new-users-excel/211291-how-do-i-print-lines-blank-workbook.html)

Carla Missouri

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?

Arceedee

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?


OssieMac

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?


AnotherNewGuy

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?



All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com