Post: #1
hi all,
how to print excel sheet with rows and columns.i tried to print rows and columns ..i am getting data only not rows and columns what settings to be made to print the rows and columns and heading in a excel sheet
Quote this message in a replyReply

Post: #2
hallo sir

please select the columns and rows which u want to print, then click on borders and reselect "all borders" from drop down list.

[Image: 2uz2xcn.gif]
[Image: 2ajsyo8.jpg]
Quote this message in a replyReply

Post: #3
cnureddybv గారిచ్చిన వివరణకు దృశ్య రూపం క్రింద చూడండి

[Image: 1ae87c76.gif]
Quote this message in a replyReply

Post: #4
Another method:

Without actually inserting table borders in your worksheet, you can print gridlines using print option. See image below you will understand.

Wait for a while to load image.............

[Image: excelprintgrid.jpg]


Screen shot is from Excel 2010 version. Similar option is also available with lower versions of Excel (Go to print set up option)

You are not allowed to view links. Register or Login to view.
Quote this message in a replyReply

Post: #5
(30-Jan-2011 12:46 AM)DRK Reddy Wrote: You are not allowed to view links. Register or Login to view.Another method:

Without actually inserting table borders in your worksheet, you can print gridlines using print option. See image below you will understand.

Wait for a while to load image.............

[Image: excelprintgrid.jpg]


Screen shot is from Excel 2010 version. Similar option is also available with lower versions of Excel (Go to print set up option)
EASY TIP తెలియచేసినందులకు ధన్యవాదాలు DRK Reddy గారు,

[Image: 2uz2xcn.gif]
[Image: 2ajsyo8.jpg]
Quote this message in a replyReply

Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)