Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do I print only horizontal gridlines in an excel worksheet?

I only want to print horizontal gridlines in excel for a project. How should
I do so?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: how do I print only horizontal gridlines in an excel worksheet?

Here's how to print only the horizontal gridlines in an Excel worksheet:
  1. Open the Excel worksheet that you want to print.
  2. Click on the "Page Layout" tab in the ribbon at the top of the screen.
  3. Click on the "Sheet Options" button in the "Page Setup" section.
  4. In the "Sheet Options" dialog box, under "Gridlines", uncheck the box next to "Vertical".
  5. Click on "OK" to close the dialog box.
  6. Click on the "File" tab in the ribbon.
  7. Click on "Print" in the left-hand menu.
  8. In the "Settings" section, click on the drop-down menu next to "Print Active Sheets".
  9. Select "Print Selection" from the drop-down menu.
  10. Click on the "Print" button to print the worksheet with only the horizontal gridlines.

That's it! Now you should have a printed copy of your Excel worksheet with only the horizontal gridlines. Let me know if you have any other questions or if there's anything else I can help you with.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,510
Default how do I print only horizontal gridlines in an excel worksheet?

You can use Format-Cells-Borders and just insert the horizontal borders
using a fine line and then under Page Setup on the Sheets tab ensure that the
gridlines box is not checked.

Regards,

OssieMac

"Arih" wrote:

I only want to print horizontal gridlines in excel for a project. How should
I do so?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Horizontal Gridlines not matching secondary Y-axis Steven Charts and Charting in Excel 3 September 14th 06 07:26 PM
In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- 4most New Users to Excel 3 July 9th 06 01:45 AM
print excel worksheet gridlines without data al Excel Worksheet Functions 1 December 2nd 05 02:06 PM
How to set DEFAULT print options in Excel to print gridlines? LKR Excel Discussion (Misc queries) 1 September 23rd 05 06:16 PM
Cannot print gridlines in worksheet even tho they show on screen papadip Excel Discussion (Misc queries) 3 June 6th 05 03:42 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"