does excel have presentation mode

Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

• Get Started
• Access 2021 Beginners
• Access 2021 Advanced
• Access 2019
• Access 2019 Advanced
• Access 2016
• Copilot in Microsoft 365 for Beginners
• Copilot Essentials in Microsoft Office
• Microsoft Excel 365 Essentials
• Microsoft Excel 365 Advanced
• Microsoft Excel 365 Intermediate
• Excel 365 for Beginners
• The Accountants Excel Toolkit
• Microsoft 365
• OneNote Desktop and Windows 10
• OneNote 2016
• Outlook 2021
• Outlook 2019
• Outlook 2016
• Outlook 2013
• Outlook 2010
• Introduction to Power Automate
• Power BI Essentials
• Power BI Training
• Power BI Intermediate
• PowerPoint 365 for Beginners
• PowerPoint 2021
• PowerPoint 2019
• PowerPoint 2016
• PowerPoint 2013
• Project 2021 Advanced
• Project 2021 Beginners
• Project for the Web
• Project 2019
• Project 2019 Advanced
• Microsoft Publisher 365
• Publisher 2013
• SharePoint Online: The Essential Guide (2023)
• SharePoint Online (2021)
• SharePoint Foundation 2013
• SharePoint Server 2013
• SharePoint Foundation 2010
• Microsoft Teams (2023 Update)
• Macros and VBA for Beginners
• VBA for Excel
• VBA Intermediate Training
• Microsoft Visio 2019
• Microsoft Visio 2010
• Windows 11 Advanced
• Windows 11 (2023 Update)
• Windows 10 (2020 Update)
• Microsoft Word 365
• Word 2019 Advanced
• Dreamweaver CC
• Dreamweaver CS6
• Dreamweaver CS5
• Dreamweaver CS4
• Adobe Illustrator CC for Beginners
• Adobe InDesign CC for Beginners
• InDesign CS6
• InDesign CS5
• Adobe Photoshop CC Advanced
• Adobe Photoshop CC Intermediate
• Adobe Photoshop CC for Beginners
• Photoshop CS6
• Photoshop CS5
• Photoshop Elements 2022
• Photoshop Elements 2019
• Photoshop Elements 2018
• Photoshop Elements 15
• Photoshop Elements 14
• QuickBooks Online 2024
• QuickBooks Desktop 2024
• QuickBooks Desktop 2023
• QuickBooks Desktop Pro 2022
• QuickBooks Pro 2021
• AngularJS Crash Course
• Bootstrap Framework
• HTML/CSS Crash Course
• HTML5 Essentials
• Java for Beginners
• JavaScript for Beginners
• jQuery Crash Course
• MySQL for Beginners
• PHP for Beginners
• Advanced PHP Programming
• Matplotlib, Seaborn, and Plotly Python Libraries for Beginners
• Python Object-Oriented Programming
• Pandas for Beginners
• Introduction to Python
• SQL for Beginners
• SQL Server Integration Services for Beginners
• XML Crash Course
• Alteryx Advanced
• Introduction to Alteryx
• Introduction to Data Visualization and Business Intelligence Principles
• Analytical Methods for Effective Data Analysis
• Introduction to Analytics and Artificial Intelligence
• Data Analytics in Excel
• Financial Risk Management
• Financial Forecasting and Modeling
• Qlik Sense Advanced
• R Programming
• Tableau Desktop Advanced
• Tableau Desktop
• Advanced Agile Scrum
• Agile Scrum Training
• Using ChatGPT to Increase Accounting Productivity
• AI In Action: Transforming Financial Operations
• Using Generative AI for Images and Videos
• Generative AI and Cybersecurity
• Introduction to ChatGPT
• Introduction to Asana for Project Management
• Asana for Employees and Managers
• Introduction to Asana
• Effective Communication Tactics for the Modern Workplace
• Introduction to Confluence
• Introduction to Pipedrive
• HubSpot CRM for Beginners
• Google Slides for Beginners
• Introduction to Google Chrome
• Introduction to Google Calendar
• Introduction to Google Drive
• Gmail for Beginners and Pros
• Getting Started in Jira
• Getting Started in Monday.com
• Cybersecurity Essentials: Stay Safe and Secure Online
• Cybersecurity Awareness Essentials
• Introduction to Wrike for Project Management
• Excel Efficiency and Data Management
• Excel Advanced Features and Customization
• Mastering PivotTables
• Microsoft Suite Productivity

How to Enable Full Screen in Excel? 3 Simple Ways

(Note: This guide on how to enable full screen in Excel is suitable for all Excel versions including  Office 365 )

Have you ever felt that when watching a movie or while surfing the internet, the full-screen mode gives you a more immersive experience? Yes, full-screen mode is effective with almost every application ranging from entertainment to professional purposes. It enhances the way we look at data and improves user interaction. 

Did you know that you can expand the screen size in Excel for a better experience of the application? In this article, I will tell you how to enable full screen in Excel in 3 simple ways.

You’ll Learn:

Why Switch to Full-Screen Mode in Excel?

Using the ribbon display options, using the shortcut keys, using the quick access toolbar.

Related Reads:

How to Wrap Text in Excel? With 6 Simple Methods

How to Enable Excel Dark Mode? 2 Easy Methods

How to Create an Excel Slicer? 2 Easy Ways

If you are probably wondering why you would want to switch to full-screen mode, there’s probably more than one reason. In addition to giving you a full-screen user experience, Excel offers you some additional features:

• Enabling full screen in Excel hides the ribbons and the options tray. However, if you feel like there is a need for ribbons, you can enable and disable them anytime you like.
• Enabling the full-screen mode makes more space for rows and columns to be visible. In the Normal mode, you’d have 28 rows compared to the 37 rows in full-screen mode.
• For some applications, when you’re using them in full-screen mode, the application becomes view only, or you cannot use the program or some of its features. Whereas in Excel, you can use the application as you use it in the normal mode. 

How to Enable Full Screen in Excel?

Initially, there was an easy option to enable full screen in Excel with just the click of a button. You’d just have to navigate to View and in the Workbook Views section, click on the Full Screen. And if you wanted to exit the full screen, right-click anywhere on the screen and click on Close Full Screen.

But, this option is not available in Excel 2013 and the following versions like Excel 2016, Excel 2019, Excel 2021, and Office365.

However, there are a couple of additional ways and methods you can use to enable the full screen in Excel in the newer versions.

This is one way to enable full screen in Excel. When using this method, you don’t have to navigate to any specific ribbon or tabs.

• Click on the dropdown from Ribbon Display Options in the right corner of the ribbons tab.
• Click on Full-screen Mode .

• This immediately hides the ribbons and additional buttons on the Excel window leaving only the worksheets tab visible. 

• To disable the full-screen mode and return to the normal mode, click on the ellipsis button in the top-right corner of the window near the close button.

• This in turn enables the ribbons and the options tray.
• Again, click on the dropdown from Ribbon Display Options and click on Always show Ribbon .
• This reverts the Excel window to its normal mode. 

Note: You can see the taskbar appearing even when the full-screen mode is enabled. This is because the taskbar is a feature of the operating system and not an Excel function. If you want to hide the taskbar too, go to Taskbar Settings and check the checkbox for the Automatically Hide the Taskbar option.

How to Hide and Unhide Columns in Excel? (3 Easy Steps)

How to Stop Excel From Rounding? 4 Easy Ways

How to Freeze Rows in Excel? 4 Easy Steps

This is by far the easiest way to toggle between full-screen mode and normal mode in Excel. You can use the shortcut keys to enable full screen mode while using any operation or function.

• To enable the full screen in Excel, hold the Ctrl key and press the Shift + F1 altogether i.e. press the keys Ctrl+Shift+F1 .

• If you want to return to the normal mode, press the same keys ( Ctrl+Shift+F1 ) you used to enable the full-screen mode.

The Quick Access Toolbar offers a variety of options to perform a variety of functions all with just a click of a button. If you are a person who is comfortable working in full-screen mode and a mouse, then adding the full-screen button to the Quick Access Toolbar might be a better option.

• First, check if you have the Quick Access Toolbar enabled. If you cannot see the Quick Access Toolbar, click on the dropdown from Ribbon Display Options . From the dropdown, select Show Quick Access Toolbar .

• Once you can see the Quick Access Toolbar, click on the Customize Quick Access Toolbar option. Click on More Commands .

• This opens the Excel Options dialog box. From the Choose commands from dropdown, select All Commands .
• Scroll down until you see the Full Screen option.
• Select it and click on Add .

• This adds the Full Screen button in the Quick Access Toolbar.

• If you want to enable the full-screen mode, just click on the Full Screen button in the Quick Access Toolbar.

• If you want to exit the full-screen mode and revert to the normal mode, just press the Esc key. 

Suggested Reads:

How to Remove Spaces in Excel? 3 Easy Methods

How to Convert Text to Numbers in Excel? 5 Easy Methods

How to Insert Bullet Points in Excel? 5 Easy Methods

Frequently Asked Questions

How do i exit a full screen in excel.

To exit a full screen in Excel, try pressing the Esc key or use the same method you used to enable the full screen mode.

Why can’t I find the full screen option in Excel 2016 or Office365?

The option to enable full screen mode in Excel was only available in versions prior to Excel 2013. In Excel 2016 and later versions, you can only use the ribbon display option, shortcut keys, or by adding the full screen option to the Quick Access Toolbar.

If I close my Excel window, will it restore to normal mode?

If you enable the full screen mode in Excel, you can exit by pressing the Esc key. If it doesn’t work, you can save the file and hard quit by pressing the close button. If you open Excel, it opens in Normal mode.

Closing Thoughts

Full screen in Excel is a very helpful feature that greatly enhances the user experience. Once you start using Excel in full screen mode, you might fall in love with the experience.

In this article, we saw how to enable full screen in Excel in 3 easy ways. Depending on your preferences you can choose the method that suits you the best. 

If you need more high-quality Excel guides, please check out our  free Excel resources  center. Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to  140+ IT training courses . Click  here  for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Similar Posts

The Most Used Powerpoint Shortcuts – Download

How to Customize QuickBooks 2019 Forms – Part 1

Working with Anchor Points and Creating Shapes with InDesign CS6

How to Use the Organizer Workspace in Photoshop Elements 15

Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)

Managing Microsoft Outlook 2010 with Mailbox Rules

• Privacy Policy

ADVANCE YOUR CAREER

Gain instant access to 200+ courses. Earn a CERTIFICATE each time you complete a course.

How to create your presentation using Excel?

Hrideep barot.

• Presentation

MS- Excel, widely known as Excel, is famous for its spreadsheets and data handling. But little has been explored of this wonderful software other than the standard features.

Do you know that you can create and give your presentation using Excel? Are you curious of how to create a presentation in Excel?

Read till the end to get familiar with the steps and bonus tips in the end!

This is our game plan for this article.

Is excel presentation a good choice?

Step 1: choose a template, step 2: create slides, step 4: remove the grids, add a background picture, add colors to your data, font size matters, make use of cells, title slide, conclusion slide, product sales, comparative analysis, financial resolution or budget proposal, who all can benefit through excel presentations, does excel have presentation mode, how to export excel presentations.

Now, you might wonder: how can a simple spreadsheet be made presentable, especially a business report or pitch?

Well, using Excel might be more advantageous than you think. Here’s why:

Although PPT or PowerPoint Presentations gives a wide variety of options and templates to choose from, it can sometimes be too stretched out or contain lots of information that can be overwhelming.

Often, the main agenda of the presentation gets blurred, as we tend to emphasize and explain each and everything on the PPT.

If you want to give a crisp, short and effective presentation, then consider going for an Excel presentation.

There are fewer chances of your audience losing focus, as you emphasize only the needed information, especially if you are presenting a business report.

You will also save time of giving and making your presentation.

Now that you know why Excel is a good choice, let us see how we can use an Excel sheet in a presentation.

Creating a presentation in Excel

Creating a presentation in Excel can be the easiest way of making a presentation.

Follow these steps to make your presentation in excel:

The first step is to choose a template that goes with the aim of your presentation.

If your aim is to give a business presentation, you can go for templates like the ones seen in the above picture.

If you aim to present a business idea or budget, then you can choose templates such as planner and checklist or expense budget.

Choosing the right template would make things easier for you and your audience.

You might wonder how can I possibly create a slide in excel? Isn’t that a feature of PowerPoint?

Well, the idea is to create one similar to PowerPoint.

By using the sheets as slides, one can easily create an impactful presentation.

Make sure to name the sheets, and arrange them in order to give a smooth presentation.

Step 3: Organize your data

Now enter your required data and arrange it.

Simply select the required data by pressing the SHIFT key and use the ARROW keys to select.

Then, click on the Insert option from the menu tab and click on the Recommended Charts.

Now, select the type of chart you want.

Here are some possible options:

If you have data that depicts a financial report, and you want to explain the profits annually, then go for Line Graphs.

Remember to name your chart. You can click on the chart title to rename it.

If you want to present a monthly report on the expenses, then go for a pie chart.

Pie charts fit well when you present on a single aspect or topic.

Tables work for almost all purposes.

However, the information presented needs to be simple and short.

You can do this by making colored tables.

You can select your data, and from the Page Layout option from the menu, browse the themes and colors.

Go for lighter tones, as they look aesthetic and professional as well.

Also, the audience won’t find it difficult to read the data, which can happen if you use darker colors.

One of the main features of Excel are the grids, i.e., rows and columns.

Our last step is to get rid of the grids, as they can distract the audience and you may also run the risk of giving a shabby presentation.

To remove grids, go to the Page Layout option in the menu tab and unselect or uncheck the boxes under Gridlines and Headings.

After this step, your presentation would seem as if it was made using a PPT!

Tips for making a creative and professional presentation using Excel

Level up your presentation by setting a background picture in your Excel sheets!

In order to do this, go to the Page Layout and click on Background.

You can choose any of your saved pictures or choose from almost infinite options by searching one.

After you choose your picture, click on insert and your background picture is ready!

Last step is to remove the gridlines for a clean presentation.

You can also remove Headings and Formula Bar by unchecking them from the View tab.

It is quite a task to locate and understand data when everything is of the same color.

In other words, when you have a single color, say white, the audience would be busy tallying the data from right to left and not be able to concentrate on your presentation.

To resolve this issue, make your tables with two color tones.

You can choose them from Themes in Page Layout.

Here is the final result:

This table would take less time to locate the data in one row, as the color makes the task easy!

I bet you took some time to read this, especially if you are looking from a laptop or PC.

Did you feel any difference?

Your eyes were strained as you tried to read what was written.

Hence, make sure to have a decently larger font for making your information visible to everyone as not everyone sees your presentation from the same proximity as you.

If you don’t want a background picture, you can go for an image.

For adding an image, go to Insert and click on Illustrations.

You can add pictures, shapes, icons, 3D models and many more.

Remember to uncheck the Gridlines and Headings, before adding the images.

Cells in a spreadsheet can be used in creative ways.

Apart from entering data and doing calculations in a breeze, they can be turned into text boxes!

So make use of them as far as you can.

You can add in the main heading in the first sheet along with a background picture.

You can also use cells for short descriptions or notes below the tables or data for better comprehension for the viewers.

This is very important for all types of presentations and not just for Excel.

The main reason to categorize is to avoid “data dump”.

This happens when you put in too much information in one chart or sheet.

You might get confused or zoned out while presenting, and it is overwhelming from an audience’s perspective as well.

So, divide your data into various sheets and name them, ensuring they are in right order.

Doing so will also give your presentation a better clarity.

Sample Excel presentation

Suppose you are from the Sales department and are asked to give a presentation to the senior executives about the current vaccination drive status and future prospects.

Considering the period to be Jan-June 2021, here is a possible sample of how you can go about giving your presentation using Excel:

Here you can talk about your views on how the organization should carry forward the vaccination drive, and give suggestions on how to do it more efficiently.

What are some good Excel presentation topics?

Excel is a good medium to present product sales. The sample presentation above is a type of product sales.

It gives the organization a clear idea of the direction of the sales of a product and planning further marketing strategy.

If you have just begun your journey as an entrepreneur or are in the sales and marketing field, here is a useful article for you to enhance your skills of giving a business pitch to your clients! Pitch Perfectly: Crucial Public Speaking Tips for Startup Founders

Some topic ideas for product sales can be:

• Annual product review in XYZ branch
• Sales review of XYZ product
• Review of top-selling products in XYZ zone
• Sales promotion review 2020-21

Comparative analysis can be presented using Excel most effectively.

You can show data in simple charts and graphs, and compare the metrics using parameters such as time( weekly, monthly, annually) or regionally( within a company or branch, across branches, or internationally).

Some topics you can consider:

• Comparative analysis of student population taking XYZ stream/course
• Analyzing weekly donations to XYZ foundation
• Regional analysis of reported crimes in XYZ state
• Health and hygiene: A correlational study

Excel is a go-to application when it comes to finances.

With its easy tools and graphics, you can present budget proposals and financial resolutions with utmost ease.

You can consider these topics:

• FDIs for the year 2018-22
• Shares review 2020-21
• Annual review: Financial department
• Funds report: XYZ branch 2020-21

Although Excel is a great tool, it is not suitable for every type of presentations and professions.

It is an excellent medium for those engaging in quantitative data such as:

• researchers
• sales and marketing
• data analysts
• corporate executives
• logisticians, etc.

You can present your data in full-screen mode or presentation mode in Excel!

To do this, go to the View tab and select Full-screen mode, or press CTRL+ SHIFT+F1.

To go back to normal mode, right-click and choose the close full-screen option, or click on the three vertical dots on the top of the screen.

To export your Excel presentation, follow these steps!

STEP 1: Go to Files tab and select Export option.

STEP 2: In Export, click on create PDF/XPS document and name your file.

STEP 3: Click on Publish. Done!

Although we went through the steps of making an Excel presentation, do not leave the other aspect out!

Your body language and delivery style also matters!

If you are confused on what approach to take regarding body language while giving a speech, follow this article! To walk or stand still: How should you present when on stage?

For preparing your voice, follow along How to prepare your voice for a speech: Step-by-step guide .

We took a look into the steps for creating a creative and effective Excel presentation in just 4 steps!

Hope that the steps and tips would make your next Excel presentation a success and completely reinvent the way Excel is seen!

Enroll in our transformative 1:1 Coaching Program

Schedule a call with our expert communication coach to know if this program would be the right fit for you

How to Brag Like a Pro as a Speaker

Less is More! Tips to Avoid Overwhelming Your Audience 

What does it mean to Resonate with the Audience- Agreement, Acceptance, Approval

• [email protected]
• +91 98203 57888

Get our latest tips and tricks in your inbox always

Copyright © 2023 Frantically Speaking All rights reserved

How to Enable and Exit Full Screen in Excel (Complete Guide)

Why Use Full Screen in Excel?

Enabling full-screen mode expands the viewable area, allowing you to see more columns and rows simultaneously. When you use Full Screen in Excel, the toolbar, ribbon, and status bar disappear, leaving only the spreadsheet visible. Here’s why it’s beneficial:

• Increased Space : Full screen mode provides more space, allowing you to view additional rows. For example, on my screen, I can see 30 rows in full-screen mode compared to 22 in normal mode (actual figures may vary based on screen size).
• Improved Concentration : With distractions minimized, full screen mode is ideal for tasks like making presentations, visualizing data, and entering information efficiently.

Methods to Enable Full Screen

1. using keyboard shortcut.

• Press  Ctrl+Shift+F1  to activate full-screen view.

Click on the image to enlarge

2. Using Ribbon Display Options

• Click the  Ribbon Display Options  icon in the lower-right corner of the ribbon.
• Select  Full-screen mode  from the dropdown menu.

• To exit full screen, click the three dots icon in the upper-right corner temporarily and then choose to leave the ribbon.

3. Using Quick Access Toolbar (QAT)

• Click the arrow icon on the left of the page under the ribbon.
• Select  More Commands  from the dropdown menu.
• In  Excel Options , choose  Quick Access Toolbar  >  All commands  >  Full Screen .
• Add the command and click OK .

• You will see a full-screen icon in the Quick Access Toolbar .

4. Using VBA to Enable Full Screen

• Open the  Developer  tab and select  Visual Basic .

• Insert a new module to enter VBA code.

• Enter the following code:

• Run the module to activate full screen view.
• How to Exit Full Screen in Excel

You can easily exit full screen mode in Excel using one of the following methods:

1. Keyboard Shortcut

• Apply the keyboard shortcut  Ctrl+Shift+F1  to exit full screen.

2. Press the Esc Button

• Simply press the  Esc  button to exit full screen mode. This option works when you activate full screen from the Quick Access Toolbar .

3. Ribbon Display Options

To exit full screen view in Excel, follow these steps:

• Click the three dots icon in the top right corner.
• Select  Ribbon Display Options  and choose  Always Show Ribbon .
• This will exit full screen mode.

4. Using VBA to Exit Full Screen

If you prefer VBA, follow these steps:

• Go to the  Developer  tab and choose  Visual Basic .
• Enter the following code in a new module:

• Running this module will return Excel to its default view.

Things to Keep in Mind

• If you work with multiple monitors, Excel’s full screen mode may apply to only one monitor.
• Not all shortcut keys are available in full screen mode, but you can still use Ctrl+S or Ctrl+Z .
• In full screen, Excel may cover the taskbar and Windows controls, so you’ll need to exit full screen to access them.

Frequently Asked Questions

1. How do I open Excel in maximized window mode?

• Press  Alt+Space  on the keyboard and select  Maximize  from the dialog box.

2. Does Excel open in normal mode after closing full screen mode?

• No, Excel always saves the last window size, so it will open in the mode it was closed.

3. How can I switch between different workbooks or windows while in full screen mode?

• Easily switch between workbooks or application windows by pressing  Alt+Tab  together on the keyboard.

4. Does full screen mode affect printing or page layout?

• No, full screen mode only temporarily affects the display. Printing and page layout remain unaffected.

5. If I close my Excel window, will it restore to normal mode?

• Yes, closing Excel using the  Esc  button or the Close icon will restore it to normal mode.

6. Why can’t I find the full screen option in Excel 2016 or Office 365?

• Full screen mode is not available after Excel version 2013. You can use Ribbon Display Options, keyboard shortcuts, or the full-screen button on the Quick Access Toolbar in Excel 2016 and later versions.

Download Practice Workbook

You can download the practice workbook from here:

Excel Full Screen: Knowledge Hub

• [Fixed!] Excel Spreadsheet Opening Larger Than Screen
• How Do I Stop Excel from Opening in Full Screen

<< Go Back to Excel Worksheets  | Learn Excel

What is ExcelDemy?

Tags: Excel Worksheets

Maruf Hasan, a BSc Electrical & Electronic Engineering graduate from Ahsanullah University of Science & Technology, boasts over a year of service as an Excel & VBA Content Developer at Exceldemy. He authored 30+ insightful articles and offers solutions to diverse Excel challenges. Maruf's exceptional content reflects his passion for Microsoft Office, problem-solving, and writing. Committed to simplifying complex processes, he significantly contributes to Exceldemy and is deeply enthusiastic about continuous learning in Microsoft Office Suite and data... Read Full Bio

Leave a reply Cancel reply

ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.

Contact  |  Privacy Policy  |  TOS

• User Reviews
• List of Services
• Service Pricing

• Create Basic Excel Pivot Tables
• Excel Formulas and Functions
• Excel Charts and SmartArt Graphics
• Advanced Excel Training
• Data Analysis Excel for Beginners

Advanced Excel Exercises with Solutions PDF

How to switch to Excel full screen mode

by Ilker | Feb 26, 2020 | Excel Tips & Tricks

Excel’s toolbar and Ribbon contain many features and shortcut icons that are aimed for improving productivity. On the other hand, these icons actually take a lot of space in your screen. Thus, your work space becomes a bit more limited. A full screen, or close-to-full-screen view can greatly increase the work area visibility. In this guide, we’re going to show you how to switch to Excel full screen mode.

Excel versions have different type of full screen approaches. Let’s see them all.

Switch full screen mode in Excel 2016 and higher versions

When the Excel window is active, press Ctrl + Shift + F1 on your keyboard to switch full screen. Although, the Mac version doesn’t have a dedicated shortcut, you can use the generic Control + Command + F to make the window full screen. However, the Ribbon will stay.

Ribbon Icon

By default, Excel doesn’t have the Full Screen icon in the Ribbon. However, this command can be added manually. Follow the steps to open Excel Options and add the command into the Ribbon.

• Right-click on the Ribbon and click on the Customize the Ribbon , or go to File > Excel Options > Customize Ribbon
• Select All Commands in Choose commands from dropdown
• Scroll down to the commands list until you find Full Screen and select it
• Click the New Tab button on the right side of the window to add a new tab into the Ribbon. Excel also adds a group under the new tab.
• Optionally you can rename the new tab and the group using Rename
• Click Add when Full Screen is selected
• Click OK to apply your changes

After these steps, you can find the Full Screen command under the new tab in the Ribbon.

Another way to enable or disable the full screen mode is using a simple VBA code. The Application.DisplayFullScreen property value defines the full screen mode. Give True to switch to full screen. Alternatively, you can set it to False to return back to the normal view.

Here are sample codes:

Switch full screen mode in Excel 2013

Excel 2013 actually does not support a full screen mode, and we do not know why it may have been removed from the 2013 version. However, you can hide the formula bar and the Ribbon to mimic the same functionality.

To hide the Ribbon, press the Ctrl + F1 keys, or right-click on the Ribbon and click on the Collapse the Ribbon item.

You can find the option for hiding the formula bar on the View tab. Uncheck the Formula Bar checkbox to hide.

You can inf more information about hiding the formula bar in How to hide and unhide formula bar in Excel .

Switch full screen mode in Excel 2007 or 2010

The Full Screen command can be found on the View tab in the Ribbon.

Press the Esc key to exit from the full screen mode.

Related posts

Recent Posts

• What's New in SpreadsheetWeb - August 2024
• How to Implement Dynamic Excel Calculations in Retool Through SpreadsheetWeb API Integration
• Building a Dynamic Calendar Application in SpreadsheetWeb
• SpreadsheetWeb for Small Business: Big Data Solutions for Small Budgets
• Integrating SpreadsheetWeb API with Salesforce

TechRepublic

Account information, share with your friends.

Use custom views in Excel to enhance your presentations

Your email has been sent

You want to illustrate your talk by pointing out selected areas of your worksheets. Rather than interrupting the flow of your presentation by having to scroll to and position each area as needed, you could create custom views in Microsoft Excel, which you can readily access by clicking on a list in your toolbar.

First, you will need to create custom views. To do so, follow these steps:

• Go to and select the worksheet area for your view.
• Go to View | Custom Views.
• Click the Add button, and then enter a name for the view and click OK.

Repeat these steps for each custom view you want to present. To build the custom toolbar for your presentation, follow these steps:

• Go to Tools | Customize.
• Click the Toolbar tab and click New.
• Enter a name for your toolbar (for example, Presentation).
• Click the Commands tab.
• Click View under Categories.
• Click Custom Views under Commands and drag it to your custom toolbar.
• Click Close.

To quickly go to a view during your presentation, click the drop-down arrow on the Custom View button and select the view from the list.

Miss a tip?

Check out the Microsoft Excel archive , and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Subscribe to the Developer Insider Newsletter

From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

* - indicates required fields

Sign in to TechRepublic

Lost your password? Request a new password

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support .

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

Want to receive more TechRepublic news?

You're all set.

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.

Viewing Your Work Full-Screen In Excel

Key takeaway:.

• Full-screen viewing in Excel maximizes your workspace: By removing toolbars, ribbons, and other distractions from the screen, full-screen viewing gives you a larger workspace to view and analyze your data.
• Full-screen viewing improves focus and concentration: By eliminating unwanted distractions, full-screen viewing can help you concentrate on your work and improve your productivity.
• Full-screen viewing enhances visualization and analysis of data: With more screen real estate, you can view and analyze your data more efficiently, especially when working with large datasets or complex graphs.

Struggling to view your Excel spreadsheet in full-screen? You don’t need to worry anymore. This article outlines simple steps to help you quickly enable full-screen view in Excel, making your workflow far more efficient.

Overview of Full-Screen Viewing in Excel

In Excel, you have the option of viewing your work full-screen, which maximizes the visibility of your spreadsheet. This feature is useful when presenting to an audience or working on a larger screen, as it reduces potential distractions. You can easily switch to full-screen view by selecting the appropriate option in the “View” tab or by using the keyboard shortcut. Once in full-screen mode, you can still access all of Excel’s functionality. Additionally, it is also possible to exit full-screen view just as easily.

When opening an Excel spreadsheet or working on one, you might be interested in maximizing the visibility of your content. One way to achieve this is by switching to full-screen view. You can do this by either selecting the option under the “View” tab or using the keyboard shortcut . Full-screen view is an excellent tool for presentations or simply working on a larger screen. It allows you to eliminate possible distractions and de-clutter the workspace. You can always exit full-screen view and return to normal view without losing any functionality.

It’s worth noting that full-screen view doesn’t modify any data in your spreadsheet nor does it prevent you from performing any operations . Instead, it is simply a visual tool that can be utilized whenever you wish. When exiting full-screen view, Excel will automatically save your progress.

Don’t miss out on the convenience of full-screen view in Excel. Impress your audience or simply enjoy working on a larger screen by utilizing this feature.

How to View your Work Full-Screen in Excel

View work full-screen in Excel? Let’s focus! Maximize the Excel window or use full-screen mode. That gives more space to work with and reduces distractions. Two sub-sections show how: Maximizing the Excel window , and using full-screen mode . There you have it!

Maximizing the Excel Window

When working on Excel, it is important to utilize the full-screen view to maximize your workspace. Here’s how to do it in Excel.

• First, find the “View” tab located at the top of your Excel window.
• Click on “Full Screen View” under the “Workbook Views” section.
• Finally, once you’re done working on full-screen mode, press the “Esc” key or click “Restore Down” to go back to regular viewing mode.

Using full-screen view on Excel can help minimize distractions and allow you to focus on your task at hand. It also makes it easier to navigate through large spreadsheets with numerous columns and rows.

Pro Tip: Instead of having extra toolbars showing in your Excel window, use keyboard shortcuts for fast navigation and efficient work. Get ready to say goodbye to distractions and hello to productivity with Excel’s full screen mode.

Using the Full Screen Mode in Excel

To optimize your Excel viewing experience, we recommend utilizing the full-screen mode. Maximize your workspace with this tactic and improve focus on important data . To do this, click on the View tab at the top of the screen and select Full Screen from the drop-down menu.

Once you have selected Full Screen mode , all distractions will be eliminated from view and only the sheet being worked on will be visible. There will be no ribbon or window frame to take up any space. For a quick transition in and out of full-screen mode, use shortcut keys “ command control F ” on Macs or “ alt enter ” on PCs.

It is essential to note that in full-screen mode, some keyboard shortcuts may not work as expected. Nonetheless, it does provide an increased visibility without losing a table’s context with auto-filtering options still available.

Did you know that there are many Excel add-ins that can enhance productivity? Check out Microsoft’s official Excel Add-ins web page for more information.

Get ready to see your spreadsheets in a whole new light and say goodbye to squinting with Full-Screen Viewing in Excel !

Benefits of Full-Screen Viewing in Excel

Maximize your Excel work! View it in full-screen mode for improved focus and concentration. This aids efficiency and helps you avoid distractions. Plus, it boosts data visualization. Easily identify trends and insights!

Improved Focus and Concentration

Optimizing the view of your Excel spreadsheet to occupy the entire screen has been proven to enhance concentration levels and focus. As our brains are wired to give priority to the primary stimuli, filling the screen with data helps cut out external distractions.

With a full-screen view, all minor details can be put aside, leaving only what’s essential in focus. This leads to fewer mistakes and improved accuracy since there are no visual disruptions while working on tasks requiring analytical and problem-solving skills. Maximizing your screen allows for a more unobstructed display of data that enables you to concentrate on one thing at a time.

Furthermore, as we shift from managing paper spreadsheets to digital ones, it’s essential to optimize viewing screens for maximum productivity. By utilizing this feature, individuals can focus better and have fewer interrupted workflow sessions.

In one instance, a financial analyst was having trouble keeping up with their demanding schedules due to constant interruptions caused by incoming emails and notifications while working rapidly through their Excel spreadsheets. The individual found that using full-screen mode not only helped remove any outside distractions but also allowed them to keep track of vital metrics without jumping between different windows or programs- making their work-life much more comfortable.

Get ready to see Excel the way it was meant to be seen – full screen and fully loaded with data analysis power!

Enhanced Visualization and Analysis of Data

Enhancing Your Data Analysis and Visualization Experience

Excel is a powerful tool for data analysis and visualization. Utilizing Excel’s full-screen view feature can significantly enhance your experience by providing a larger and clearer display of your work.

Using the full-screen view feature also provides a more immersive experience that helps reduce eye strain and improves concentration. This feature can be enabled through the View tab in the Excel ribbon.

Don’t miss out on optimal productivity when analyzing massive amounts of data in Excel! Enable full-screen viewing today and see an improvement in your productivity. Start enjoying the benefits of enhanced visualization and analysis now!

Get ready to experience Excel in its full glory with these tips for optimizing your full-screen viewing experience.

Tips for Optimizing Full-Screen Viewing Experience in Excel

Maximize your Excel viewing pleasure! Tweak settings to get the most out of your screen. Speed up your work with shortcuts and hotkeys. Follow these hints to boost productivity and be more efficient .

Adjusting Excel Settings for Optimal Full-Screen Viewing

To fully optimize your Excel Full-Screen Viewing experience, you will need to make some adjustments to the settings. Here’s how to do this in a professional and informative manner:

• Customize the Quick Access Toolbar : The Quick Access toolbar is located at the top left corner of your screen and contains frequently used commands. By customizing it, you can easily access essential commands needed for full-screen viewing.
• Choose the Best View : There are various view options in Excel such as Page Layout, Normal, and Page Break Preview that offer different views based on your preference. Experiment with each one to see which suits your work best.
• Change Zoom Settings : Zoom in and out of worksheets to achieve optimal readability while working on them in full-screen mode.
• Adjust Display Options : Fine-tune display options to change excel background color, gridlines, headings, fonts etc., for easier navigation of data within the software.

It’s important to note that optimizing each setting can improve both productivity and overall user experience while working on large excel documents and spreadsheets that require extensive use of formulas and data manipulation techniques. By maximizing these settings you avoid missing out on Excel’s full suite of visualization tools which – as any expert will know – can mean missing out on important insights.

Utilizing Excel Shortcuts and Hotkeys for Efficient Workflow.

Optimizing your workflow by using Excel shortcuts and hotkeys can help you save time and boost productivity. By leveraging these efficient techniques in Excel, you can streamline your work process to achieve better results quickly.

Here’s a 4-step guide on how to use Excel shortcuts and hotkeys for efficient workflow:

• Learn the most commonly used shortcuts: Familiarize yourself with the most frequently used keyboard shortcuts such as Ctrl+C (copy), Ctrl+V (paste), and Ctrl+Z (undo) .
• Customize your own shortcuts: You can create custom keyboard commands that suit your specific needs. For instance, you may assign customized keyboard shortcuts to frequently-used tools.
• Create Macros: Macros are a set of instructions that automate repetitive tasks. Creating macros enables you to perform complex operations with a single keystroke.
• Select range or data quickly: You can select a row or column by pressing the Ctrl+Shift+arrow key . Using the Shift+F8 hotkey allows you to activate the “extend selection” mode, enabling you to select non-adjacent cells simultaneously.

In addition, mastering advanced Excel Keyboard Shortcuts, like moving between sheets, activating formatting options will further increase efficiency when working on spreadsheets.

Using Excel shortcuts is not only an excellent way of saving time but also helping avoid errors that could occur during manual processes.

Have you ever spent hours performing repetitive calculations without knowing there was a shortcut?A client once told me he’d been completing financial reports for months before discovering an easier way via hotkey mapping.

Five Facts About Viewing Your Work Full-Screen in Excel:

• ✅ You can enter full-screen mode in Excel by pressing the F11 key on your keyboard. (Source: Excel Jet)
• ✅ Full-screen mode maximizes the Excel window, hiding the ribbon, scroll bars, and formula bar to give you more space to work. (Source: Tech Community Microsoft)
• ✅ You can exit full-screen mode by pressing the Esc key or pressing F11 again. (Source: Tech Community Microsoft)
• ✅ Full-screen mode is ideal for presenting Excel data to others or for working with large spreadsheets and pivot tables. (Source: Excel Easy)
• ✅ Full-screen mode is available on all versions of Excel, including Excel for Mac and Excel Online. (Source: Excel Campus)

FAQs about Viewing Your Work Full-Screen In Excel

What is full-screen view in excel.

Full-screen view in Excel is a feature that allows you to maximize your working space by taking Excel to the full size of your screen. This allows you to have a clear and better view of your work, enabling you to work more efficiently.

How can I enter full-screen view in Excel?

To enter full-screen view in Excel, click on the View tab on the top ribbon, then select Full Screen. Alternatively, you can press the F11 key on your keyboard to enter full-screen view.

How do I exit full-screen view in Excel?

To exit full-screen view in Excel, simply press the Esc key on your keyboard. Alternatively, you can click on the View tab on the top ribbon, then select Exit Full Screen.

What are the benefits of viewing my work full-screen in Excel?

Viewing your work full-screen in Excel has several benefits, including a more productive and focused work environment, a clearer and better view of your work, the ability to work on multiple spreadsheets without distraction, and the ability to easily switch between Excel and other applications.

Can I still access the Excel ribbon in full-screen view?

Yes, you can still access the Excel ribbon in full-screen view by moving your cursor to the top of the screen. This will reveal the Office ribbon, where you can access all the features and functions of Excel.

Is it possible to view two or more spreadsheets side by side in full-screen view?

Yes, it is possible to view two or more spreadsheets side by side in full-screen view. To do this, click on the View tab on the top ribbon, select Arrange All, then choose whether you want to view your spreadsheets horizontally or vertically. This will allow you to work on multiple spreadsheets simultaneously in full-screen view.

• Kutools for Excel
• Kutools for Outlook
• Kutools for Word
• Kutools for PowerPoint
• Setup Made Simple
• End User License Agreement
• Get 4 Software Bundle
• 60-Day Refund
• Tips & Tricks for Excel (3000+)
• Tips & Tricks for Outlook (1200+)
• Tips & Tricks for Word (300+)
• Excel Functions (498)
• Excel Formulas (350)
• Excel Charts
• Outlook Tutorials
• ExtendOffice GPT ExtendOffice GPT Assistant
• About Us Our Team

Feature Tutorials

• Search Search more
• Retrieve License Lost License?
• Report a Bug Bug Report
• Forum Post in Forum
• Contact Us 24/7 email

Explore the new, free version of Kutools for Outlook today!

How to switch to full screen in Excel?

This article compares two ways of getting full-screen mode in Excel, which can be helpful for you to expand the work area flexibly.

• Full-Screen Mode in Excel
• Switch to full screen and other two types of screen view with Kutools for Excel

  Full-Screen Mode in Excel

Amazing! Using Efficient Tabs in Excel Like Chrome, Edge, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!

The full-screen mode of Excel will hide the ribbon, status bar, and formula bar.

In Excel, click on the View tab and uncheck all types in the Show group to make the screen full. See screenshot:

  Switch to full screen and other two types of screen view with Kutools for Excel

Kutools for Excel, a robust third-party add-in, offers several options to maximize the Excel workspace, making it easier to focus on your data without the distraction of menu ribbons or toolbars. These options are conveniently accessible via a floating toolbar located in the upper right corner of the Excel window. Here’s a breakdown of the screen view options provided by Kutools for Excel:

After installing Kutools for Excel , you can quickly switch to full screen view by applying Work Area .

1. Click Kutools > View > Work Area . See screenshots:

2. As soon as clicking Work Area , Excel will be switched to the full screen view which hides formula bar, status bar and ribbon, see screenshot:

Click the second icon to hide status bar，see screenshot:

• Click the third icon to hide status bar and formula bar, see screenshot:

If you want to stop or exit this utility, just click the first icon in the Work Area Size , it will return to the normal view.

• To use this feature, you should install Kutools for Excel first, please click to download and have a 30-day free trial now.
• To know more detail information about Work Area , go to Work Area Size .

Best Office Productivity Tools

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.   Click Here to Get The Feature You Need The Most...

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Microsoft Excel

11 minute read

11 Best Excel Presentation Tips in 2024

Brandon Pfaff

Facebook Twitter LinkedIn WhatsApp Email

Join the Excel conversation on Slack

Ask a question or join the conversation for all things Excel on our Slack channel.

There’s more to a spreadsheet than just the numbers on the page. It is equally important to make your spreadsheets look professional, easy to read, and visually appealing to your viewers.

The same way a lawyer with a crooked tie and disorganized papers might raise an eyebrow in court, your Excel presentation won’t hit the right marks with your audience if it looks clumsy and bland, no matter how many hours of research goes into making it or how important the information contained within it is.

Whether you are creating a spreadsheet for personal use, to pass information to your team or share with your project manager, the secrets locked away in this post will be of immense use to you. Let’s take a look at the best Excel presentation tips to help you create standout spreadsheets .

Free Excel crash course

Learn Excel essentials fast with this FREE course. Get your certificate today!

1. Get a template online

If you are a busy person, and you cannot fit an Excel presentation design into your schedule, enter the ex machina: pre-made Excel templates. You can choose from an array of purpose-specific templates with beautiful designs, fonts, and colors. Simply enter your values to customize it, and you are ready to go.

Of course, using a template means you will not get better at designing things yourself. If getting things done is your priority instead of getting better at designing presentations, then, by all means, use a template and be done with it. On the other hand, if you want to know how to make your Excel presentation better on your own, then find someone to teach you or stick around until the end of this post.

Check out our 50 best Excel templates to make your life easier  and our  33 Excel business templates for workplace productivity .

2. Name your worksheets correctly

Excel presentation is all about clarity. For this single reason, the importance of a correct and reliable project or worksheet name cannot be overemphasized. It could be a sentence, a phrase or just a word. Just make sure it is easy to understand by you or by anyone you will be sharing the file with.

You also must make sure it is distinct from the names of other worksheets stored on your computer. After all, what is the use of all the tips you will learn here today if you will not be able to find the worksheet you applied them on?

3. Define your header/title

Your header and title can be anything but it needs to stand out. Your header must be able to speak to the reader and make the reader know at first glance what the header is.

To do this, try a larger font for your header, underline and embolden it. You should center align it and use a different font color. It has to stand out but also blend with the template color scheme and overall aesthetic look. You can also use a different readable for your header. Just remember, we want to make it distinct, not isolated.

Step up your Excel game

Download our print-ready shortcut cheatsheet for Excel.

4. Dos and don'ts of fonts

Full transparency: Fonts make or break your spreadsheet. Always use a uniform font for your data, you can use the same font for your header or you can change that of the header. You can use three fonts in a single presentation and that is the recommended maximum, else you would be pushing it. In this case, less is infinitely better.

These are the guidelines to follow in selecting the right format for your font.

Here is a quick tip, fonts of the sans-serif group are the best for your Excel spreadsheet if readability is your goal. Calibri, Helvetica, Arial or Playfair are few examples. If used with the right alignment, spacing, and color, they can bring out the best in your Excel presentation.

This ultimately depends on your presentation but officially, font 12 is often advised with double spacing to improve readability. As stated earlier, the header font can be larger. The headers should be larger than sub-headers which in turn should be larger than data fonts.

You want to create a sharp contrast between the text color and the background colors e.g. a light color text on a dark background and vice versa. This is where the "zebra stripes" rule comes in, which will be discussed later in the post.

People don’t often use the alignment tool in Excel. If you want to make your presentation look beautiful and business-like , you will need to maximize the alignment feature.

5. Create space for breathing room

When you see tightly packed, clumsy or wordy text or spreadsheet, your brain automatically gets tired of reading it before you even start. But when there is breathing space and the spreadsheet is divided up into categories, it becomes more pleasant to the eyes and ripe for interpretation by the brain.

This brings us to the B2 rule. Try to start your presentation on column B, row 2. Leaving the A column and the first row blank. It works like magic. You should also make sure that the column and row dimensions are the same.

Additionally, don't autofit the height and width of your document. You need to have flexibility and creative control of your workspace. Instead, manually adjust the height and width so that they have just enough white space but not too much to give your presentation some breathing room and improve readability.

6. Add an image

Whether it’s a photograph, an artistic sketch or your logo, images go a long way in making your spreadsheet better. Images make your presentation look official and possess the professional feel in many of the beautiful presentations you have seen. Pictures speak a thousand words. While Excel is not designed to accomplish the kind of presentation you can make in PowerPoint, a picture will help you to drive the point home and make your presentation memorable.

7. Go off the grid

Do you know that erasing all grid lines apart from those of your result will have people asking how you did it and if you used the same Excel software they use? Try it today. In your spreadsheet

Go to the View tab on the ribbon.

• Under the Show section, uncheck the box next to Gridlines .

8. Zebra stripes: Excel jungle law

Zebra stripes are alternating dark and light colors on rows lying on top of each other. This helps in a number of ways. First, it has this aesthetic feel that makes your work seem orderly, especially if you are displaying hundreds of rows of data. Second, it helps correlation and readability. A reader can track a row from the right-hand side to the far left and not lose track of what row his or her eyes are set upon.

You can zebra stripe using many methods. When you create a table in Excel, by default this will be zebra striped (Tip- select your data and use the shortcut Ctrl + T on a PC or ^ + T on a Mac to quickly create a table). On the Design tab, under Table Styles, you can change the color and style of your zebra stripes.

It can also be done using a formula in conditional formatting if desired. Conditional formatting is done by highlighting values that satisfy certain requirements (e.g. all odd-numbered rows). It can be copied from cell to cell using the painter tool in the Home toolbar.

9. Use charts, tables , and graphs

Most presentations are incomplete without some form of visual representation. Whether table, graph or chart, you need to visually represent your raw data in mediums that would be understood in a single glance. Charts, graphs, and tables should not be underestimated, especially if you have cumbersome data spanning many columns and rows.

In the Excel ecosystem, the chart, graph, and table features are like symbiotic siblings. You need them to bring out the beauty in the brevity of your work.

10. Create cell styles

Excel has many preset cell styles but you can create your own custom styles that will be more customized, and easier to use and edit because you created it. This is actually an alternative to getting a template if graphics consistency is your goal. After creating a beautiful spreadsheet with the above information, you can save the style so that you can apply it to future presentations.

Now your presentation is perfect with the right feel and style. Simply highlight the cells with your design for saving, then go to the Home toolbar, click on "more" at the base of the style gallery, then select "new cell style". A style dialog box will open, name the style, edit its properties and save.

If it isn't broken and it works efficiently, why change it? You can, however, add a touch of variability by changing the color palette from time to time.

11. Show restraint

You have learned all of these tips and you are ready to start your presentation -  be careful of overdoing it. Use color sparingly and don't combine too many tips at once. You need to tread the fine line between underwhelming and too much to find the "just enough" middle ground. Make sure your presentation is perfectly balanced, as all things should be.

Ultimately, the way your Excel presentation turns out depends on how well you communicate your data to your audience. Although, it does help to know the psychology of colors, good fonts. Browse beautiful spreadsheet presentations online to figure out what the "best" looks like. But at the end of the day, the ball is in your court and we hope that your dedication to practicing, sharpening and perfecting your presentation skills in Excel will be rewarded with cheers.

Ready to design your own Excel presentations?

If you would like to sum up the data on your Excel spreadsheet so that its insights are conveyed in a straight-forward manner, then follow this step-by-step guide. You’ll end up with a presentation that summarizes your data in a way that’s painless to analyze.

If you’re eager to brush up on your Excel skills, check out our Excel course and master the fundamentals to boost your productivity.

Loved this? Subscribe, and join 461,165 others.

Get our latest content before everyone else. Unsubscribe whenever.

Brandon is a full time CPA specializing in all things tax. When he is not serving clients, he enjoys spending time with his wife and son, real estate investing, and sipping fine bourbon.

Recommended

How to Use the IFS Function in Excel

The IFS function in Excel returns different results based on the result of progressive logical tests. It is a newer alternative to nesting multiple IF statements.

What Excel Skills Are Employers Looking For?

Excel skills are required for most admin, engineering, and management jobs and can provide a pathway to high-paying jobs if you don't have a college degree.

Excel Challenge 43: Assign Random Values From a List

Test your skills with this Excel challenge: create random schedules for athletes and display dynamic rosters. Dive in, explore our resources, and get started!

© 2024 GoSkills Ltd. Skills for career advancement

🍪 This website uses cookies to improve your experience.

Learn more about our cookies Accept cookies

Apr 8, 2020

Synchronize changes while you are presenting

• Add our blog to your RSS feed reader" href="/rss/blog.xml" data-bi-name="RSS Subscription" data-bi-id="rss_feed" data-bi-bhvr="120" data-bi-socchn="RSSSubscription" title="Microsoft 365 Insider Blog RSS" target="blank" class="d-inline-block">

Hi, I’m Lishan Yu, a Program Manager on the PowerPoint team. I’m excited to share a new capability that will give you confidence you’re sharing the latest information when presenting.

For years, PowerPoint didn’t allow changes made to slides by others to be displayed while presenting. This ensured that the presenter was in full control of the content being shared. No one could revise slides, either accidentally or maliciously. It also ensured that all of your computer resources were used for slideshow rendering. A concern that is especially important if you are running on a low-end machine.

However, while some presenters may still desire this original design, we’ve heard from others that they are seeking more flexibility. With an increased focus on collaboration and real-time updates, we’re excited to make available the ability to synchronize changes whenever they are made, even when the presentation is in Slide Show mode.

How it works

You can synchronize changes in two ways: automatically or manually.

Automatically update slide content

 1. Select the  Keep Slide Updated  check box on the  Slide Show  tab on the ribbon.

 3. Whenever an update to a slide is made and detected, the content is automatically updated and visible in the slide show being presented.

Manually update slide content

 1. Clear the  Keep Slide Updated  check box on the  Slide Show  tab on the ribbon.

2. Start the presentation by selecting the appropriate button on the  Slide Show  tab.

3. Whenever an update to a slide is made and detected, an  Update Slides  button appears at the top of Presenter View.

4. Click the  Update Slides  button to manually synchronize the slide content.

Scenarios to try

• During a slide show with multiple presenters, fix a typo or make couple edits to your slides while others are presenting.
• When you are driving a collaborative meeting, ask your audience to add their questions directly on your Q&A slide, and have a more open, engaging, and interactive presentation.

Availability

This feature is available to presenters running Insider Fast builds on Windows and Mac.

• Windows: Version 2004 Build 16.0.12728.20000 or later.
• Mac: Version 16.35 Build 20022603 or later. Mac presenters can only manually update slide content at the moment. Stay tuned for when auto-update is available.

Your presentation must be stored in OneDrive for Business or SharePoint to use this feature.

We typically release features over some time to ensure that things are working smoothly. This is true for Insiders as well. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as Insiders, have had the opportunity to try them.

Give it a try and let us know how your feel – do you need it? Do you like it? Are you worried about losing control? Do you think social norm is strong enough to keep it sane?

Submit your comments and concerns using the Help Improve Office button in the top right corner or click  Help > Feedback . Include  #SlideshowSync  in your feedback to make sure we see it. 

Learn what  other information you should include in your feedback  to ensure  it’s actionable and reaches the right people. We’re excited to hear from you! 

Sign up for the  Office Insider newsletter  and get the latest information about Insider features in your inbox once a month!

Sorry, JavaScript must be enabled to use this app.

American Graphics Institute

Excel tutorial: switching display modes in excel, how to switch display modes in excel.

The default viewing mode in Excel is the Normal mode, and it is primarily used when you are working with your data. There are times when you want to switch the display to see what your worksheet will look like when printed, or you may just want to view where the page breaks will occur, and you can use various display modes to see these things. You can quickly change the viewing mode of your worksheet by using the buttons in the Status bar. You’ll learn more about printing in Lesson 2, “Creating a Worksheet in Excel 2013.”

1 Switch to Page Layout mode by clicking the Page Layout button.

Choose the Page Layout mode.

2 Switch to Page Break Preview mode by clicking the Page Break Preview Button.

3 Click Normal to return the regular viewing mode.

Change the size of the worksheet display

You may need to change the size of your worksheet display, especially if you are working with data that extends beyond the visible area. Using the Zoom tool in the Status bar, you can quickly reduce or enlarge the worksheet display.

Change the size of your worksheet display by dragging the Zoom slider.

1 Click and drag the Zoom slide to enlarge the display area to 125%.

2 Drag the slider to 100% to return the view to its original size.

Take a class from the authors of this tutorial

See available Excel classes and learn from the expert instructors at American Graphics Institute. In-person classes at our locations, online courses, or private training is available.

Tutorials Category: Excel Tutorials

These tutorials are created by Jennifer Smith and the team of expert instructors at American Graphics Institute.

• Use Presenter view Video
• Set up your presentation Video
• Deliver your presentation Video

Use Presenter view

With Presenter view, the audience views your slides on a main screen, while you control the show on another screen that only you can see.

View your speaker notes as you deliver your slide show

Draw on or highlight slides during a presentation

Turn your mouse into a laser pointer

Add speaker notes to each slide in a presentation

PowerPoint is all about helping you give great presentations; and the Presenter view is all about helping you use PowerPoint.

Traditionally, the audience faces a screen showing your PowerPoint slides, and you stand in between the audience and screen, and change slides on a computer.

Unless you are a professional presenter, you may also have to juggle paper notes, or attempt to wing it by reading off your slides.

Presenter view lets you take advantage of the dual monitor capability of a computer to separate what the audience sees from the mechanics of running a slideshow.

The audience views your slides on the main screen, while you control the show with the Presenter view on another screen that only you can see.

The Presenter view is like a dashboard that contains in one window everything that you need to run your show.

You have your notes over here.

This monitor shows you what the audience sees minus transitions, effects, and videos.

And this monitor shows you what is coming up next.

You have all your tools here, which you can select out of view of the audience.

And you click here to move forward or back.

There is even a timer that starts when you begin your presentation, and a clock.

By running the Presenter view on a laptop, just below eye level, you can face the audience and never have to look back at the screen.

You can do things like select a Laser Pointer or drawing tool, or use the Slide Navigator to select a different slide.

And only you can see all this behind-the-scenes stuff, so the audience can stay focused on your message.

Presenter view also helps you stay focused.

All the controls are easy to get to in one window with big icons, and a simple design.

So, if you are interested, let's give the Presenter view a try.

In the next video, we'll set up a presentation.

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

• Search forums
• Board Rules

Follow along with the video below to see how to install our site as a web app on your home screen.

Note: This feature may not be available in some browsers.

• If you would like to post, please check out the MrExcel Message Board FAQ and register here . If you forgot your password, you can reset your password .
• Question Forums
• Excel Questions

Put Powerpoint into "Presentation" mode from within Excel?

• Thread starter VBAProIWish
• Start date Jan 11, 2012

VBAProIWish

Well-known member.

• Jan 11, 2012

Hello All, Does anyone know how to put Powerpoint into "Presentation" mode from within Excel? I have this code here to start it up and allow for copying and pasting. Maybe just one more line? Code: 'Sub AAAAChartToPresentation3() ' Set a VBE reference to Microsoft PowerPoint 10.0 Object Library for Office 2002, Dim PPApp As PowerPoint.Application Dim PPPres As PowerPoint.Presentation Dim PPSlide As PowerPoint.Slide Dim oPPT As PowerPoint.Application Set oPPT = CreateObject("PowerPoint.Application") ' Sub PasteChartintoPP2() ' ' PasteChartintoPP Macro ' Keyboard Shortcut: Ctrl+Shift+A ' Dim PPApp As PowerPoint.Application ' Dim PPPres As PowerPoint.Presentation ' Dim PPSlide As PowerPoint.Slide Dim PresentationFileName As Variant ' Reference existing instance of PowerPoint Set PPApp = GetObject(, "Powerpoint.Application") ' Reference active presentation Set PPPres = PPApp.ActivePresentation ' Reference active slide Set PPSlide = PPPres.Slides _ (PPApp.ActiveWindow.Selection.SlideRange.SlideIndex) Thanks  

Excel Facts

• Jan 12, 2012

PPPres.SlideShowSettings.Run  

Jaafar Tribak

VBAProIWish said: Yes Yes Yes, thank you for that! Now, if I may ask... 1. Can I tell Excel VBA to maximize the PowerPoint window? 2. Can I tell Excel VBA to bring focus to that maximized PowerPoint window? Click to expand...

If the AppActivate doesn't work then use this : ( Changes to your code are in red ) Code: [COLOR=Red]Private Declare Function GetWindowThreadProcessId Lib "user32" _ (ByVal hwnd As Long, _ lpdwProcessId As Long) As Long Private Declare Function AttachThreadInput Lib "user32" _ (ByVal idAttach As Long, _ ByVal idAttachTo As Long, _ ByVal fAttach As Long) As Long Private Declare Function GetForegroundWindow Lib "user32" _ () As Long Private Declare Function SetForegroundWindow Lib "user32" _ (ByVal hwnd As Long) As Long Private Declare Function IsIconic Lib "user32" _ (ByVal hwnd As Long) As Long Private Declare Function ShowWindow Lib "user32" _ (ByVal hwnd As Long, _ ByVal nCmdShow As Long) As Long Private Declare Function SetWindowPos Lib "user32" _ (ByVal hwnd As Long, _ ByVal hWndInsertAfter As Long, _ ByVal x As Long, _ ByVal y As Long, _ ByVal cx As Long, _ ByVal cy As Long, _ ByVal wFlags As Long) As Long Private Declare Function FindWindow Lib "user32.dll" Alias "FindWindowA" _ (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Declare Function PostMessage Lib "user32.dll" _ Alias "PostMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, _ ByVal wParam As Long, ByVal lParam As Long) As Long Private Const GW_HWNDNEXT = 2 Private Const SW_SHOW = 5 Private Const SW_RESTORE = 9 Private Const WM_SYSCOMMAND = &H112 Private Const SW_MAXIMIZE = &HF030&[/COLOR] Sub AAAAChartToPresentation3() ' Set a VBE reference to Microsoft PowerPoint 10.0 Object Library for Office 2002, Dim PPPres As PowerPoint.Presentation Dim PPSlide As PowerPoint.Slide Dim PresentationFileName As Variant Dim oPPT As PowerPoint.Application [COLOR=Red] Dim hwnd As Long[/COLOR] Set oPPT = CreateObject("PowerPoint.Application") oPPT.Visible = True [COLOR=Red]hwnd = FindWindow(vbNullString, oPPT.Caption)[/COLOR] ' Reference existing instance of PowerPoint Set PPApp = GetObject(, "Powerpoint.Application") ' Reference active presentation Set PPPres = PPApp.ActivePresentation ' Reference active slide Set PPSlide = PPPres.Slides _ (PPApp.ActiveWindow.Selection.SlideRange.SlideIndex) [COLOR=Red]BringWindowToFront hwnd Call PostMessage(hwnd, WM_SYSCOMMAND, SW_MAXIMIZE, 0)[/COLOR] End Sub [COLOR=Red]Private Function BringWindowToFront _ (ByVal hwnd As Long) As Boolean Dim ThreadID1 As Long Dim ThreadID2 As Long Dim nRet As Long On Error Resume Next If hwnd = GetForegroundWindow() Then BringWindowToFront = True Else ThreadID1 = _ GetWindowThreadProcessId(GetForegroundWindow, ByVal 0&) ThreadID2 = _ GetWindowThreadProcessId(hwnd, ByVal 0&) Call AttachThreadInput(ThreadID1, ThreadID2, True) nRet = SetForegroundWindow(hwnd) If IsIconic(hwnd) Then Call ShowWindow(hwnd, SW_RESTORE) Else Call ShowWindow(hwnd, SW_SHOW) End If BringWindowToFront = CBool(nRet) End If End Function[/COLOR]  

Ok, very close. It DOES bring focus to PowerPoint, but, if the PowerPoint screen is not already maximized, it simply brings focus to it, but doesn't change it's window size. Is there some code like..? Code: Window.PowerPoint.Maximize Thanks for the help  

Strange. The PostMessage line should maximize the PP main window. To maximize a PP doc ( not the main PP app window ), I believe you should try : Code: oPPT.Windows(1).WindowState=ppWindowMaximized  

You know what, my bad on this. For some reason, I mistakenly thought that this code... Code: PPPres.SlideShowSettings.Run put PowerPoint into presentation mode, but after trying it again, it did not. And now that I think about it, how could it be in presentation mode and NOT be full screen. Again, my apologies. I looks like I'm back to square 1. Although I haven't tried your larger code yet. The code for bringing focus to PowerPoint works though.  

Similar threads

• Oct 2, 2023
• tbakbradley
• Aug 17, 2024
• Jun 12, 2023
• Jul 5, 2024
• Jul 10, 2023

Forum statistics

Share this page.

We've detected that you are using an adblocker.

Which adblocker are you using.

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock

How to Enable or Disable The Presentation Mode Settings in Windows 11/10

Presentation Mode is a feature in Windows 10 designed to help people carrying their Presentations on their portable devices. The User can specify certain settings like volume to be set, screensaver to be used, desktop background to be in place in Presentation mode and when the Presentations mode is enabled, these changes are done to the OS.

• Only people with Admin rights can enable or disable the Presentation Mode Settings
• This feature is only available in Windows Pro, Enterprise, and Education versions.

In this article, let us see how to enable or disable Presentation Mode Settings in Windows 10 in two different ways.

Method 1: Using Registry Editor

Step 1: Open the Run Dialog using the keys  Windows+R

Step 2: Type  regedit  and hit  Enter

Step 3: In the UAC window that opens asking for permissions, click on  Yes

Registry editing can harm the system even with the slightest mistake. It is advised to take the backup of the registry before proceeding. To take a backup, In the Registry Editor–> Go to  File –> Export –> Save your Backup file .

Step 4: In the Registry Editor window, on the search bar at the top, copy-paste the following location

Step 5: If you cannot see the PresentationSettings folder, create one, right-click on Policies, choose New > Key.

Step 6: Name the folder as PresentationSettings

Step 5: Open the PresentationSettings  folder.

Step 6: On the right-hand side, right-click anywhere on the empty area.

Step 7: ChooseNew > DWORD(32-bit) Value.

Step 8: Name the newly created Key NoPresentationSettings

Step 9: Double-click on the key to change its value.

Step 10: To Turn Off or disable the Presentation mode settings, Set the value to 1 click OK

Step 11: If you want to enable the settings ,  set the value to 0 .

Step 12: Restart the System.

Method 2: Using Group Policy Editor

Step 1: Open the Run Command Window using Windows+R.

Step 2: Type gpedit.msc and hit Enter.

Step 3: In the Local Group Policy Editor window that opens, from the left-hand side, navigate to the following location. Simply double-click on the section to expand the selection.

Step 4: On the right-hand side, double-click Turn off Windows presentation settings.

Step 5: To disable this setting, tick on the Disabled option.

Step 6: To Enable, click on the Enabled option.

Step 7: Finally click on the Apply button, followed by OK.

NOTE: Ensure that this setting is applied. If not,

1. Open Run Dialog using Windows+R

2. Type cmd and hold the keys Ctrl+Shift+Enter to open a command prompt in Admin mode.

3. Type  the below command and hit Enter

Step 8: Restart your System.

That’s All

We hope this article has been informative. Thank you for Reading.

Kindly comment and let us know which fix helped you solve the issue.

• How to Enable / Disable Airplane Mode in Windows 11
• How To Enable Or Disable Performance Mode In Microsoft Edge
• How to Enable Developer Mode in Windows 11
• How to Use and Enable Focus Assist Mode on Windows 11
• How to Enable Dark Mode for Calculator App in Windows 11
• How to Enable New Details Pane in File Explorer With…

This site uses cookies, including third-party cookies, to improve your experience and deliver personalized content.

By continuing to use this website, you agree to our use of all cookies. For more information visit IMA's Cookie Policy .

Change username?

Create a new account, forgot password, sign in to myima.

Multiple Categories

Excel: Full-screen Mode and Sketch Types

November 01, 2021

By: Bill Jelen

They say no one knows every feature in Excel. This adage must apply to the Excel team in Redmond, Wash., because they just added a new full-screen mode feature to Excel when the old Full Screen View was never actually removed.

Why would you need full-screen mode in Excel? It might be useful when you need to display a lot of numbers on a kiosk display, but no one will actually be interacting with the spreadsheet. The ribbon interface is hidden, and you can display the maximum number of rows able to fit on the screen.

There was a Full Screen View in Excel more than a decade ago. I went looking for it in 2019 and found a 2013-era Microsoft Knowledge Base article saying that Full Screen View was removed from Excel as of the release of Excel 2013. This wasn’t a great loss for me since I rarely used full screen. After all, they removed it in 2013, and I didn’t miss it until six years later.

A “NEW FULL-SCREEN MODE”

Recently, the beta version of Excel introduced a new choice in the drop-down menu at the bottom-right corner of the ribbon. As shown in Figure 1, you can now choose full-screen mode. How exciting: A full-screen view is back.

There are a number of statistics that are often cited when discussing the quality of a monitor, such as display size, aspect ratio, resolution, and so forth. But for me, it all comes down to one important question: How many rows and columns can I see in Excel?

The number of rows visible in Excel depends on your monitor size, display settings, and the font you’re using. For the sake of comparison, all of these statistics are from the same 24-inch monitor:

• If you choose “Always show Ribbon,” you can see 37 rows in Excel.
• If you choose “Show tabs only,” you can see 42 rows in Excel. The shortcut for this setting is Ctrl+F1.
• If you choose “Full-screen mode,” you can see 46 rows in Excel. In this mode, you see a green title bar, the formula bar, the column letters, 46 rows of the grid, and then the ribbon tabs and status bar. To exit this mode, use the “three-dots” icon at the top-right to temporarily display the ribbon, and then open the same drop-down shown in Figure 1. Alternatively, Ctrl+Shift+F1 will toggle in and out of this mode.

The return of the full-screen mode is a somewhat interesting conversation if you’re talking to people who spend most of their working week using Excel. It was a great factoid to tell people: “Microsoft took Full Screen View out of Excel eight years ago, and they just brought it back.” But after sharing this fact with a number of people, I encountered two people who told me that they’ve been using Toggle Full Screen View every day of their lives continuously for many years.

After investigating, it turns out that there has been an icon that you could add to the Quick Access Toolbar to get into the “discontinued” Full Screen View. Right-click the ribbon and choose Customize Quick Access Toolbar. From the top-left drop-down menu, choose All Commands. Until recently, you had to scroll to the “T” section to find Toggle Full Screen View. Recently, it moved to the “F” section, under Full Screen [Toggle Full Screen View]. This ancient command, allegedly removed from Excel 2013, doesn’t show the formula bar and manages to fit 48 rows in Excel. This view is the “best” at showing the grid full screen. To exit this view, press the Esc key.

It’s a mystery why the official Excel documentation says that the “best” full-screen view has long since been removed from Excel and why it’s still there but only known to a small percentage of people using Excel. Did the engineers who designed the new full-screen mode know that this old Toggle Full Screen View was still available? I’ve asked, but they have no comment.

SKETCH EFFECTS

Full-screen mode isn’t the only feature introduced recently. The Office interface was redrawn for the release of Windows 11. The one recurring theme in the new interface is that many corners that used to be at a 90-degree angle have now been rounded. You’ll see the rounded corners in the sheet tabs at the bottom, in the name box and formula bar above the grid, and at the ends of the ribbon itself.

Another part of this theme is a new property for shapes that you add to your spreadsheet. With a shape selected, go to Shape Format and open the Shape Outline drop-down menu. A new “Sketched” flyout menu opens at the bottom, offering sketch types of “None,” “Curved,” “Freehand,” and “Scribble,” as shown in Figure 2.

Yet most of the changes announced for the new Windows 11 refresh of Excel aren’t new at all. If you’ve been a Microsoft 365 subscriber, you’ve also already had access to XLOOKUP, dynamic arrays, data types, AI, and the LET function.

About the Authors

November 2021

• Technology & Analytics
• Reporting & Control
• Information Systems
• Financial Recordkeeping
• microlearning courses
• career development

Publication Highlights

Improving Critical Thinking Skills

Explore more.

Copyright Footer Message

Lorem ipsum dolor sit amet

•  >  Excel Tips
•  >  Editing

Viewing Your Work Full-Screen

Written by Allen Wyatt (last updated December 28, 2023) This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365

There may be times when you want to see as much of your worksheet as possible. You can quickly maximize your worksheet to replace virtually everything else on your screen by displaying the View tab of the ribbon and clicking the Full Screen tool in the Workbook Views group.

When you are done working with Excel in this manner, click on the on-screen button to restore the regular view, or simply press the Esc key.

In Excel 2013 the Full Screen tool was removed, so the above technique won't work for later versions of Excel. Instead, follow these steps:

• Display the View tab of the ribbon.
• In the Show group, uncheck all the check boxes. (You may only be able to uncheck three of them or you may be able to uncheck all four. In either case, uncheck all that you can.)
• At the upper-right corner of the program window, click the Ribbon Display Options icon and choose Auto-Hide Ribbon. Excel immediately makes the ribbon disappear. (See Figure 1.)

Figure 1. Accessing the Ribbon Display Options.

• Maximize Excel's program window.

When you are done viewing the workbook in this manner, again use the Ribbon Display Options icon to display the ribbon and, on the View tab of the ribbon, select the check boxes you unchecked in step 2.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6125) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Viewing Your Work Full-Screen .

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates , a computer and publishing services company. Learn more about Allen ...

MORE FROM ALLEN

Understanding Ascending and Descending Sorts

When you sort information, Excel follows a set pattern of how your data is organized. This tip illuminates the burning ...

Ignoring Words Containing Numbers

If your writing often contains words that include numbers, you'll want to make sure you set up the spelling checker to ...

Deleting a Printer

When you get rid of an old printer and install a new one, you'll want to get rid of the old printer definition maintained ...

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

Using the Same Range Name on Different Worksheets

Defined names can be a great boon when working in a worksheet. Usually names are available throughout an entire workbook, ...

Capitalizing Just a Surname

Changing the capitalization of text is, believe it or not, a common task in Excel. Common or not, it can be frustrating ...

Importing a Subset of Records

If you only want to import a portion of whatever records are in a text file, Excel provides a number of ways you can ...

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

(Your e-mail address is not shared with anyone, ever.)

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

(gif, jpeg or png only, 5MB maximum file size)

Notify me about new comments ONLY FOR THIS TIP

Notify me about new comments ANYWHERE ON THIS SITE

Hide my email address

What is 4 - 1?

2020-08-26 18:31:50

In my Excel 2010 I could not find a Workbook Views group on my View tab. I had to create a custom group and then add the Full Screen command from the Edit Ribbon process.

2020-05-25 02:37:58

how do I stop Excel 2019 from opening workbooks in maximized mode? I always resize it to a smaller size and close it to save the setting but when I open a different workbook, it opens it maximized... How can I make Excel 2019 ALWAYS open ANY workbook in my preferred window size???? Its super annoying

2018-10-24 12:00:23

Chris van Zyl

The VBA statement Application.DisplayFullScreen = True is still (Office365, Oct. 2018) available and works; set it to false to get the ribbon etc. back. This could be incorporated into a macro which needs all available space on the screen.

2018-10-24 10:19:13

I find that crtl-F1 gets rid of the ribbon quite quickly

2018-10-24 04:53:42

Thanks Allen for all your tips (many of which are irrelevant for the way I use Excel but I pick up the occasional nuggets which help a lot). Excel 2007 - I use F10, W,E to switch the full screen (and the ESC to revert to normal). It's the same as your first suggestion except there's no need to use the mouse.

2017-02-21 08:07:44

Full screen is still availble in Excel 2013 albeit it's hidden. 1) Right click on the ribbon > Customise the Ribbon 2) Make sure you have a custom group created, if not create one 3) Choose commands From: select All Commands 4) Scroll down and select Full Screen 5) Select your custom group on the right and click on Add >>

2016-07-26 05:19:35

Even before full screen, Excel sheet row nos' 1st digit too close to left edge. Is margin adjustable? Display is flat Samsung LCD. Thank you for your help.

2014-12-03 22:52:52

Sir, Thanks for the help. this works.

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface .

Newest Tips

View the most recent newsletter.

Links and Sharing

• ExcelTips FAQ
• Questions or Comments
• Great Branding Ideas
• Free Calendars

OUR COMPANY

• Sharon Parq Associates, Inc.
• About Tips.Net
• Advertise with Us
• Our Privacy Policy
• Author Index

OUR PRODUCTS

• Helpful E-books
• Newsletter Archives
• Video Courses
• Excel Products
• Windows Products
• Word Products
• Beauty and Style
• ExcelTips (Excel 97–2003)
• ExcelTips (Excel 2007–2021; 365)
• Home Improvement
• Money and Finances
• Pests and Bugs
• Pets and Animals
• WindowsTips (Microsoft Windows)
• WordTips (Word 97–2003)
• WordTips (Word 2007–2021; 365)

Copyright © 2024 Sharon Parq Associates, Inc.