Pinterest Pixel

Quick Reports Using Excel Custom Views

Bryan
Whenever I wanted to print my Excel worksheet for a report, I usually had to trim down the data and do changes like hiding the columns so it could fit into one page.

Whenever I wanted to print my Excel worksheet for a report, I usually had to trim down the data and do changes like hiding the columns so it could fit into one page.

Other common scenarios would be, hiding employee salaries or filtering out specific customer data.

It is cumbersome because after printing it out I had to undo the layout changes one by one!

Thankfully Excel has Custom Views that lets you revert and save your layout changes in a single click!

 

Quick Reports Using Excel Custom Views | MyExcelOnline

download excel workbook Custom-Views.xlsx

 

STEP 1: You need to set a default view first.

Once you have the layout that you use most of the time, go to View > Custom Views:

Quick Reports Using Excel Custom Views

 

STEP 2: Click Add to create a new Custom View.

Quick Reports Using Excel Custom Views

 

Type in Normal View and click OK.

Quick Reports Using Excel Custom Views

 

STEP 3: In preparation for the second Custom View, select the first 4 columns, right click and select Hide.

Quick Reports Using Excel Custom Views

 

STEP 4: Go to View> Custom Views:

Quick Reports Using Excel Custom Views

 

STEP 5: Click Add to create a new Custom View.

Type in Hidden Columns and click OK.

Quick Reports Using Excel Custom Views

 

STEP 6: Let us now try out our Custom Views in action.

Go to View > Custom Views.

Select Normal View and click Show.

Quick Reports Using Excel Custom Views

 

You can see all of the columns displayed.

Quick Reports Using Excel Custom Views

 

STEP 7: Now let us try the second custom view.

Go to View > Custom Views.

Select Hidden Columns and click Show.

Quick Reports Using Excel Custom Views

 

The columns are hidden right away in a click!  Imagine if you have multiple layout customizations, it is now doable and saved in a Custom View!

Quick Reports Using Excel Custom Views

 

 

Add Hyphens To Serial Numbers Using Excel Flash Fill

If you like this Excel tip, please share it



Quick Reports Using Excel Custom Views | MyExcelOnline


Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  The Ultimate Guide on Yes No Dropdown for Excel

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...