Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts

Wednesday, October 19, 2016

Divide Excel Worksheet into Pages!!

Divide Excel Worksheet into Pages!!



Excel Page Layout View


If youre using Excel 2010/ 2013, you can divide your worksheet into individual pages. This exciting feature was unthinkable even on Excel 2003. At first, Microsoft introduced this Page Layout feature in Excel 2007. And its available in Excel 2010 and 2013 too. 


Almost all of you are familiar with the Print Layout view of Microsoft Word. Excel Page Layout view does the same job here. If you enable Page Layout view in a worksheet, you can easily understand your print area with header and footer. And it also makes your printing task easier. 


Excel 2013 Page Layout View


Applies to:
  • Excel 2007
  • Excel 2010
  • Excel 2013


Advantages of Page Layout


  • You can view how your printed document will look
  • Check where your page begins and ends
  • View headers and footers of the page
  • Print the worksheet page by page

How to Enable Page Layout View

You can enable page layout view as below:
  1. Open any worksheet or create a new one
  2. Go to the View Tab > Workbook Views > Page Layout 

Page Layout Option in View Menu


You can also use the keyboard shortcuts:

Press Alt Key > Then type WP 


If you would like to back to the Normal View then:

Press Alt Key > Then type WL 


You can also enable Page Layout view from Status Bar. I think its the most handy option. Follow the image below:


Excel 2013 Page Layout Icon


The selected icon in the middle is Page Layout icon. The left one is for Normal View. And the right one is for Page Break Preview. 






Stay with Marks PC Solution to get more interesting IT topics!




Go to link download

Read more »

Monday, August 29, 2016

Using Default Cover Pages in MS Word

Using Default Cover Pages in MS Word




Mindblowing Cover Pages by MS Word


Are you preparing a formal report? Or do you need any cover page sample for any other task? By default, MS Word contains some outstanding cover pages. Each of them will give you different flavor. Today Im gonna talk about using the default cover pages of MS Word . . . 


This Tutorial Applies to - 

  • Word 2007
  • Word 2010
  • Word 2013
  • Word 2016

In every new version, Microsoft Office changes their default templates. Same thing happens to Word cover pages. I mean, the default cover pages are not same in every version of MS Word. 


Cover pages included in Word 2016 may not be found in the previous versions of Office. Word 2016 has 16 cover pages. But you can discover more from Office.com . . .



Add a Cover Page
  1. Run MS Word.
  2. Create a new document or open an existing one.
  3. Go to the Insert tab.
  4. Hit on the Pages > Cover Page > Click on the cover which you like. Thats it.


Add a Cover Page in your Document




Stuffs you Should Know

  • When you add a page number in your document, your cover page will be counted as page number 0. So, youve to insert page number at the next page to your cover page.
  • If you add a new cover page, it will replace the first one.
  • If you need to delete the cover page, Insert Tab > Pages > Cover Page > Remove Current Cover Page (Follow the above image).
  • To delete a cover page which was created by the earlier version of word, you must remove it manually.



Hopefully this post will be of great help if you need to prepare documents frequently. Of if you are engaged with professional writing, these cover pages will reduce your time required to design your report cover. 


If you need to know more about adding cover page, then follow this link . . .




Stay with Marks PC Solution to get more interesting IT topics!




Go to link download

Read more »