Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Print sheet number and sheet name

Posted on 2013-10-28
4
Medium Priority
?
556 Views
Last Modified: 2013-10-28
Folks,
I have a need to print the associated sheet number with the sheet name. I can get the name but not the number
0
Comment
Question by:Frank Freese
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 9

Expert Comment

by:jsdray
ID: 39605826
Should be able to do that in the header and footer
0
 
LVL 9

Accepted Solution

by:
jsdray earned 2000 total points
ID: 39605839
Although Excel 2007 provides standard header and footer text that you can select from drop-down menus, you also can create a custom header or footer. In addition to typical header or footer items such as the page number, file name, and date or time, you can insert and format a picture. In addition, you can format the text in a header or footer just as you would any cell data.

To create a custom header or footer in Excel 2007, follow these steps:

Click the Page Layout button on the View tab of the Ribbon (or click the Page Layout View button on the Status bar).

Position the mouse pointer over the Click to Add Header section at the top or the Click to Add Footer section at the bottom.

Click to position the insertion point in the left, center, or right section of the header or footer area.

Excel adds a Header & Footer Tools contextual tab with its own Design tab.

Click the Design tab if it isn’t already selected, and then click any option in the Header & Footer Elements group:

Page Number: Insert a code that indicates the page number.

Number of Pages: Insert a code that indicates the total number of pages.

Current Date or Current Time: Insert the print date or time of day.

File Path, File Name, or Sheet Tab Name: Include file information.

Picture: Insert a graphic image, such as a company logo.

Format Picture: Resize, rotate, or crop a header or footer graphic image.

Use the buttons in the Header & Footer Elements group to create custom headers and footers.
Use the buttons in the Header & Footer Elements group to create custom headers and footers.
Repeat Steps 3 and 4 as needed, and also type any additional text you want for the header or footer.

You can format the header and footer text just as you would any cell data.

Click in the worksheet area and then click the Normal button on the View tab to return to Normal view.
0
 
LVL 9

Expert Comment

by:jsdray
ID: 39605844
Hope that's clear... I would send a link to the information which is layed out much more clear, but EE has a new policy and won't allow me to post outside links.... they'll delete them.
0
 

Author Closing Comment

by:Frank Freese
ID: 39605861
thanks . . . I understand the policy
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question