How do I set the settings in Excel 2000 to NOT print row numbers?

How do I set the settings in Excel 2000 to NOT print row numbers?

I still want the column headers to print. All I want to NOT print is the row numbers. I've looked in the various help tabs and at various websites, and they all seem to have steps to not print BOTH the row numbers and column headers.

Am I asking for the impossible? I thought this would be very easy, but I guess I need an expert's help, so here I am!

Note: I use Excel 2000 rather than a newer version because I use Excel for very simple projects and not that often. It still works fine in Windows 10.
RadioGeorgeOwner/ProgrammerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wayne Taylor (webtubbs)Commented:
It's both or nothing unfortunately. What you could do though is hide both headings and recreate manually the column headings in the first row.
0
JohnBusiness Consultant (Owner)Commented:
I have Excel (Office) 2000 on my Windows 2000 machine and I checked it.  All or nothing as noted above unless you wish to manually set the columns.
0
AutomotionCommented:
I'd assume that column headings are defined in the first row and if that's the case go to the top of your window where you'll find an icon (down arrow) that you can use to add the "Set Print Area" option to your ribbon.  

I'm your spreadsheet select the data you want to print, including headings, and then click on "Set Print Area."  If the row numbers still appear when you select "Print Preview" then de-select the appropriate button from the page view menu.
0
RadioGeorgeOwner/ProgrammerAuthor Commented:
Thanks to all who wrote.

As it turned out, I mentioned this to my wife who has used MS applications for a long time, and she knew EXACTLY how to designate the print area as I needed! The solution is apparently one of those neat little functions that was never included in any MS documentation, but has always existed, hiding in the caves of hyperspace where all such information is hidden from the eyes of ordinary users.

Problem solved!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.