HEADER & FOOTER IN MS-EXCEL

HEADER & FOOTER IN MS-EXCEL


MS-Excel also has the options of Header and Footer as there is in MS-Word. Here I would like to explain the Basic elements of Header and Footer in MS-Excel. 

When we click on Header and Footer option in Insert Menu, we get a New Menu called Design. First Tab which we get under Header & Footer Design Menu is Header & Footer. 

This is used to insert preset options given in the list to a document. 

Second Tab - Header & Footer Elements. 


Header & Footer opens up in a Page Layout view. It shows Ruler lines also and provides three spaces in Header & Footer area. Left, Center & Right. 
It looks like:



In these above given area we can fill the elements separately. 

The options in elements are as follows:

Page Number: This is used to Insert Page Number in the area given in Header of Footer.

Number of Pages: This is used to insert the Total Number of Pages in a worksheet.

Current Date: This is used to insert Current Date. But please note the Current Date the system Date, which is currently being displayed on the system. This date will change with the change in system date. 

Current Time: This is used to insert Current Time. But please note the Current Time the system Date, which is currently being displayed on the system. This time will change with the change in system time. 

File Path: This will display the path where you have stored your file. Normally it looks like:

C:\users\vcc\documents\book1

here vcc is used in place of computer user in example.

book1 is used in place of filename. 

These both may differ from system to system.

File Name: This displays the Name of the File in Header or Footer where ever you place it. By default or not saved it is Book1

Sheet Name: It displays the Worksheet name which may be Sheet1, Sheet2, etc. or whatever name is given to the sheet by the user.

Picture: This is used to insert a picture in Header of Footer.

Format Picture: This is dull and highlights only when a picture is inserted in Header or Footer. It pops up a dialogue box, which is used to resize the inserted picture. 



Third Tab - Navigation

Here we get two options Go to Header / Go to Footer. This is used to switch between Header and Footer.

Fourth Tab - Options

Here in options we get four more options which are 

Different First Page: If this option is selected it allows to put different Header & Footer in First page and in other pages it will remain same.

Different Odd & Even Page: If this option is selected it allows to put different Headers & Footers in Odd and Even Pages. 

Scale with Document - Specifies if the header and footer should scale if you use the "Shrink to Fit" feature. 

Align with Page Numbers - Aligns the sides of the header and footer to the page margins.

Hope the information in this blog is useful.


Please do leave a comment/query for this blog.

इस  प्रकार की कम्प्यूटर सम्बंधित जानकारी के लिए हमारी वेबसाइट पर ब्लॉग लिंक पर क्लिक करें। 


द्वारा 
कुमार वैभव 
डायरेक्टर 
वैभव कंप्यूटर सेंटर एवं कंसल्टेंसी 
वैभव सदन, देवकाली रोड, 
फैज़ाबाद, अयोध्या। 
Center website: www.vccfzd1.weebly.com


Comments

Post a Comment

Popular posts from this blog

MAIL MERGE IN PAGEMAKER

Image
  MAIL MERGE IN PAGEMAKER We all know about Mail Merge feature in MS-Word. Like Word PageMaker also provides us the facility to Mail Merge which is here known as Data Merge.  Data Merge can be found under Window Menu - Plug-in Palettes - Show Data Merge Palette . When we click on Show Data Merge Palette we get a new Tool Bar on Screen as Data Merge. On Data Merge Tool Bar we have to click on Select Data Source. Where we get a dialogue box which provides option to choose a file with extension CSV or TXT.  For making a CSV file we can easily use excel and feed the data required accordingly.  Now type a letter which has to be commonly send or matter on which data is to be merged. Here I will explain Data Merge with an Example. I had fed the following data in MS-Excel & save it as .CSV in my computer. .CSV which I had chosen shows as .CSV (comma delimited) While entering data always start with the very first cell of the sheet. And first row will always contain the headings. As I have
Read more

Paste Special in MS-Excel

Image
Paste Special in MS-Excel Paste Special in MS-Excel provides many options. When we copy any data and simply paste it to some other cell it is copied with all its settings such as formula, font size, comments, etc. which are in it.  But Paste Special provides us the facility to not to copy things which we don't want. Here I would try to describe all basic points.  First of all we will see how Paste Special looks like when we copy any data and open the Paste Special Window. It may differ from the type of data copied.  Here we can see under paste many things are written. I have already described all above. Formulas: When we copy a cell which contains formula and we want to only paste that formula on a particular cell we use this.  Value: When we want to copy the value in cell to any other place than we have to use this.  Formats: This is used to copy the formatting of a cell to another cell. For example if we have changed the font size of a cell or change the format of data to date fr
Read more

How to use Whatsapp on your Computer?

Image
How to use Whatsapp on your Computer? Most of us know that we can use Whatsapp on mobile only. In this blog I would like to share how to use Whatsapp on Computer. For using Whatsapp on Computer we should have  1. Mobile with Whatsapp installed. 2. Computer with Internet facility. 3. Browser installed on Computer (normally all computers have it). We have to open our preferred browser, you can use any Google Chrome, Microsoft Edge, Torch, etc.  Here in the address bar you have to type:  web.whatsapp.com  Once you entered this a page would appear  with QR Code  as given below: In computer following instructions appear: Once you follow the above instructions properly you can see your mobile groups and contacts on computer on left side and in right side you can see your chat.  It makes easy for you to get your data downloaded on computer or sending any computer file to your contacts.  You can send following things as attachments: 1. Create Room: With this option you can create a room for a
Read more