custom view

  1. R

    Custom View: Header resets

    I'm using Excel 2010 and recently learned about custom views. Yay! I created custom views for a report I update monthly. One version is for "The Big Boss", the other version is for me. Difference is my report has a couple columns for my random notes and the page orientation is wider to...
  2. S

    Freeze Panes re-setting after a Custom View?

    I hope there's an explanation for this. I'm setting a custom view that has certain sorts set on my data. I'm filtering by columns E and I. Once I've applied the custom view, I go to Data-> Sort & Filter-> Clear so that I can see all of my data again. When I do that, the data that was filtered...
  3. M

    Custom View not working in Excel 2007

    I have a large spreadsheet from which I need to create separate Reports by hiding various rows and columns. I have followed instructions for creating a couple of Custom Views (View tab, Custom Views, Add, Inserted Name, OK, Saved the document) but nothing happens apart from getting the message...
  4. P

    View Three Pages On Sheet

    Hi I have 8 pages on my sheet but I only want to view and work with 3,4,5. Is there anyway to hide the other pages? I'm trying to get this to work as I don't have to do a lot of scrolling when invoicing as there are hundreds to do. Thanks
  5. M

    Custom View

    In Excel 2007 why is the Custom Views button always grayed out in .xlsm files?
  6. A

    Macro to Imitate Custom Views with Data Lists

    I am working with Excel 2003 at the office. I like the Data List feature, but I really miss the Custom Views feature especially for hiding columns to simplify data entry updates. Unfortunately, the Data List feature does not allow Custom Views. My perfect macro would deal with a tab 1 that...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top