+ Reply to Thread
Results 1 to 3 of 3

How to Change View of Worksheet

  1. #1
    Registered User
    Join Date
    03-24-2016
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2013
    Posts
    37

    How to Change View of Worksheet

    Hi,
    I have a question relating to how to create sheets like this. The attached photo shows one page of A4 sheet and everything else on the worksheet is grey. I want to create the same thing but I dont know how. Also is there a way to put multiple A4 (for that matter any size sheets) next to each other with lets say one greyed out column?

    Thanks in advance
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,929

    Re: How to greate

    On the ribbon, select View. then Select Page Break Preview.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How to Change View of Worksheet

    The answer to your second question is "No."
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to Change View of WaterFall Chart?
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-01-2015, 09:04 AM
  2. Change how to view data from excel database
    By Julius Dayao in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2015, 05:38 PM
  3. [SOLVED] Change roster view
    By ixa37 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-29-2015, 04:40 AM
  4. [SOLVED] How to view data from multiple tables in one worksheet in another worksheet?
    By TechnoFonic in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-22-2013, 03:40 PM
  5. [SOLVED] can i change the view of Outlook 2003?
    By J.wills in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 03-13-2009, 06:11 AM
  6. [SOLVED] How to view a custom view when the worksheet is protected?
    By JulesJam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-06-2006, 10:20 AM
  7. How do i change my database to list view
    By m in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1