ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   lines in a spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/96551-lines-spreadsheet.html)

akinard

lines in a spreadsheet
 
i am trying to make a sign in sheet in Excel. I know how to make gridlines
appear, but those don't show up until you enter information. Is there a way
to make (empty) lines appear so I can print out a sign in sheet?

thank you.


DS-NTE

lines in a spreadsheet
 
Format - Cells - Borders

"akinard" skrev i melding
...
i am trying to make a sign in sheet in Excel. I know how to make gridlines
appear, but those don't show up until you enter information. Is there a
way
to make (empty) lines appear so I can print out a sign in sheet?

thank you.




CLR

lines in a spreadsheet
 
You can either do Right-click FormatCells Borders, for lines that are
aligned with the outsides of cells, or you can draw lines using the Drawing
Toolbar which can be moved around at will.......

Vaya con Dios,
Chuck, CABGx3




"akinard" wrote:

i am trying to make a sign in sheet in Excel. I know how to make gridlines
appear, but those don't show up until you enter information. Is there a way
to make (empty) lines appear so I can print out a sign in sheet?

thank you.


akinard

lines in a spreadsheet
 
thank you, chuck. that was a huge help.

"CLR" wrote:

You can either do Right-click FormatCells Borders, for lines that are
aligned with the outsides of cells, or you can draw lines using the Drawing
Toolbar which can be moved around at will.......

Vaya con Dios,
Chuck, CABGx3




"akinard" wrote:

i am trying to make a sign in sheet in Excel. I know how to make gridlines
appear, but those don't show up until you enter information. Is there a way
to make (empty) lines appear so I can print out a sign in sheet?

thank you.


CLR

lines in a spreadsheet
 
Happy to help, and thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"akinard" wrote:

thank you, chuck. that was a huge help.

"CLR" wrote:

You can either do Right-click FormatCells Borders, for lines that are
aligned with the outsides of cells, or you can draw lines using the Drawing
Toolbar which can be moved around at will.......

Vaya con Dios,
Chuck, CABGx3




"akinard" wrote:

i am trying to make a sign in sheet in Excel. I know how to make gridlines
appear, but those don't show up until you enter information. Is there a way
to make (empty) lines appear so I can print out a sign in sheet?

thank you.



All times are GMT +1. The time now is 02:31 AM.

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