Share via

Rows and Column lines

Anonymous
2019-07-16T14:46:16+00:00

Good morning! 

I am very new with Excel and have only had one class. 

I am trying to create a basic blank document that will print column and row gridlines, that have NO information entered into the cells. I need the cells to be blank to be written in once this document is printed (Reason: I work in property management and there was water damage to a unit. All of the damaged items in the unit need to be entered online with attached pictures. I need a sheet of paper to take to the unit, to inventory all the damaged property, then bring it back to the office and enter it online). 

I have all the categories entered in Excel (Item Description, Brand, Model #, etc.) I know how to print gridlines in Excel when there is data in the cell, but how in the world do I make them print with no entered data in a cell. HELP?? 

:) 

Thanks!!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-07-16T15:58:01+00:00

    Hi MelissaDawsonPM

    Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    Select the range which you want to print say A1:G20 > Page Layout tab > Print Area > Set print area

    Page Layout tab > Print Titles > Sheet tab > Check Gridlines

    Do let me know if you have any more question or require further help.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-07-16T15:14:10+00:00

    Hello Again ...

    There is another simple way but it doesn't uses excel instead ms word.

    1. Open Word
    2. Select Insert from Top Menu.

    1. Insert Table Option
    2. Enter No of Columns and Rows and you are done.

    Hope it helps.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-07-16T14:58:29+00:00

    Hi There...

    You may try with selecting all cells you want to print and use format as in below pic (All Borders).

    Was this answer helpful?

    0 comments