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 Intermediate
  • QuickBooks Online 2024
  • QuickBooks Desktop 2024
  • QuickBooks Desktop 2023
  • QuickBooks Desktop Pro 2022
  • 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 Modelling Using Generative AI
  • 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 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
  • Introduction to Google Docs
  • Google Slides for Beginners
  • Introduction to Google Chrome
  • Introduction to Google Calendar
  • Introduction to Google Drive
  • 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
  • Soft Skills Essentials
  • Excel Efficiency and Data Management
  • Excel Advanced Features and Customization
  • Mastering PivotTables
  • Microsoft Suite Productivity

presentation mode for excel

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 .

How to enable full screen in Excel using Ribbon Display options

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

Full screen mode in Excel

  • 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.

Disable full screen mode

  • 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. 

Select Always Show Ribbon

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 .

Enable Full Screen in Excel using Shortcut keys

  • 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 .

How to enable full screen in Excel using Quick Access toolbar

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

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 .

Select Full screen and click Add

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

Select Full Screen from Quick Access Toolbar

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

Full Screen in Excel

  • 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.

presentation mode for excel

Simon Calder

' data-src=

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

How to Mail Merge in Word

How to Setup a Chart of Accounts in Quickbooks Pro 2012

Building a Website Using Dreamweaver CS6 – Part 2

How to Remove Tables in Excel? 3 Easy Ways 

How to Adjust Display Settings in Windows 10 – User Guide and Walkthrough

How to Create Task Dependencies in Microsoft Project 2016

  • Privacy Policy

presentation mode for excel

ADVANCE YOUR CAREER

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

ExcelDemy

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

Maruf Hasan

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.

Selecting full screen view from ribbon display options

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

Full screen view using Ribbon Display Opitons

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 .

Adding Full Screen Command

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

Selecting Toggle full screen view icon

4. Using VBA to Enable Full Screen

  • Open the  Developer  tab and select  Visual Basic .

Launching Visual Basic Editor from the Developer Tab

  • Insert a new module to enter VBA code.

Selecting a New Module from the Visual Basic Editor Window

  • Enter the following code:

VBA code to enable full screen

  • 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.

Excel Full Screen using VBA

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:

VBA code to disable full screen

  • 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

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.

See Our Reviews at

trustpilot review

  • 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

DMCA.com Protection Status

Advanced Excel Exercises with Solutions PDF

ExcelDemy

SpreadsheetWeb

How to switch to Excel full screen mode

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

excel full screen

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

presentation mode for excel

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

presentation mode for excel

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:

presentation mode for excel

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.

presentation mode for excel

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

presentation mode for excel

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.

presentation mode for excel

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

Related posts

How to unhide sheets in Excel with VBA

Recent Posts

  • Integrating Excel Calculations into Workato with SpreadsheetWeb API
  • Integrating Excel Calculations into Parabola.io with SpreadsheetWeb API
  • Integrating Excel Calculations into n8n with SpreadsheetWeb API
  • Integrating Excel Calculations into Airtable with SpreadsheetWeb API
  • What's New in SpreadsheetWeb - October 2024

Microsoft Excel

11 minute read

11 Best Excel Presentation Tips in 2024

Brandon Pfaff

Brandon Pfaff

Facebook Twitter LinkedIn WhatsApp Email

presentation mode for excel

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.

Excel-presentation-tips

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.

Excel-presentation-tips

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.

Excel-presentation-tips

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.

Excel-presentation-tips

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.

Excel-presentation-tips

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.

Excel-presentation-tips

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.

Excel-presentation-tips

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 .

Excel-presentation-tips

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.

Excel-presentation-tips

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.

Excel-presentation-tips

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.

Excel-presentation-tips

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 468,212 others.

Get our latest content before everyone else. Unsubscribe whenever.

Brandon Pfaff

Brandon is a full time CPA specializing in all things tax. He is also skilled in analytics and Mircosoft Word. When he is not serving clients, he enjoys spending time with his wife and son, real estate investing, and sipping fine bourbon. Find him on Linkedin here.

Excel Challenge 45: Create an Interactive Sales Chart

Recommended

Excel Challenge 45: Create an Interactive Sales Chart

If you're creating a dashboard in Excel, an interactive chart will most likely be one of the elements. Learn how to create one in this fun scenario!

16 Best Free Excel Chart Templates for Your Business

16 Best Free Excel Chart Templates for Your Business

Download 16 of the best chart templates for business for project planning, financial management, sales, social media analytics, and more.

Excel Challenge 44: Build an Employee Performance Review Sheet

Excel Challenge 44: Build an Employee Performance Review Sheet

Create a performance review sheet in Excel with weighted scores, conditional formulas, and a radar chart. Test your skills in GoSkills’ Excel Challenge 44!

© 2024 GoSkills Ltd. Skills for career advancement

🍪 This website uses cookies to improve your experience.

Learn more about our cookies Accept cookies

Frantically Speaking

How to create your presentation using Excel?

Hrideep barot.

  • Presentation

excel presentations

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:

These are a few good options to choose from for excel presentations

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:

Using line graph can make your boring data interesting!

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.

Pie charts make a great option for presenting survey results as well!

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

stick to plain backgrounds for excel presentations

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:

use your creativity to make slides standout!

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:

Ensure to make your excel presentation title stand out!

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.

Do not forget to add a thank you slide at the end for excel presentations

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!

Hrideep Barot

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

presentation mode for excel

8 Steps to Success in the Field of Career Coaching

maid of honor speech

9 Tips for Writing a Maid of Honor Speech That Tugs at Heartstrings

10000 hours in public speaking

How the 10,000-Hour Rule Applies to Public Speaking 

presentation mode for excel

Get our latest tips and tricks in your inbox always

Copyright © 2023 Frantically Speaking All rights reserved

How to Full Screen Excel: A Simple Guide to Maximizing Workspace

Navigating Excel’s full screen mode is a piece of cake once you know the steps. This guide will walk you through how to go full screen in Excel, allowing you to maximize your workspace and focus on the task at hand. All you need is a few clicks, and you’ll be working distraction-free in no time.

How to Full Screen Excel

Going full screen in Excel can help you concentrate on your data by removing distractions. Let’s go through the steps to achieve this.

Step 1: Open Excel

Launch Excel on your computer.

First things first, you need to open the Excel application. If you don’t have an Excel file ready, just open a new blank workbook.

Step 2: Open the Excel File

Load the workbook you want to work on.

If you already have a specific file in mind, open it up. Otherwise, you can use any file to follow along.

Step 3: Navigate to the View Tab

Click on the "View" tab in the ribbon at the top.

This tab is packed with options that control how you view your workbook. Keep an eye out for it in the ribbon.

Step 4: Enter Full Screen Mode

Click on the "Full Screen" option.

In older versions of Excel, you might need to click "Full Screen" under the "View" tab, but in newer versions, hitting "Alt" and "V" together followed by "U" will do the trick.

Step 5: Exit Full Screen Mode

Press the "Esc" key to exit full screen.

When you’re done, simply press the "Esc" key on your keyboard to return to the normal view.

After you complete these steps, your Excel window will occupy the entire screen, providing you with a clutter-free workspace. You can now analyze your data without any distractions.

Tips for Full Screening Excel

  • Know Your Keyboard Shortcuts : Familiarize yourself with keyboard shortcuts like "Alt" + "V" + "U" for faster access to full screen mode.
  • Toggle Ribbon Visibility : Click "Ctrl" + "F1" to hide or show the ribbon, giving you even more screen real estate.
  • Zoom In and Out : Use the zoom slider at the bottom right to adjust the view to your liking.
  • Utilize Multiple Monitors : If you have multiple screens, drag Excel to one screen and make it full screen while keeping other apps on another screen.
  • Explore Full Screen Options : In some versions, you might have additional full screen options under the "View" tab for even more customization.

Frequently Asked Questions

How do i full screen excel on a mac.

On a Mac, click the green button on the top left corner of the window to enter full screen. To exit, hover at the top and click the green button again.

Can I use full screen mode with multiple workbooks?

Yes, you can open multiple workbooks and switch between them using "Ctrl" + "Tab" while in full screen mode.

Is there a shortcut for full screen in newer versions of Excel?

In newer versions, pressing "Alt" and then "V" followed by "U" will get you into full screen mode.

How do I make the ribbon disappear in full screen?

Press "Ctrl" + "F1" to toggle the ribbon on and off, even in full screen mode.

Why can’t I find the full screen option in my Excel?

In some newer versions of Excel, the full screen option might not be visible. You can use the "Alt" + "V" + "U" shortcut instead.

  • Open your workbook
  • Navigate to the View tab
  • Click on Full Screen
  • Press Esc to exit full screen

In a world with constant distractions, knowing how to full screen Excel can be a game-changer. It allows you to maximize your workspace, giving you an edge in productivity and focus. Whether you’re crunching numbers or preparing a presentation, a clutter-free environment helps you stay on top of your tasks.

For more handy Excel tips and tricks, be sure to explore other features under the "View" tab. Your efficiency can skyrocket just by learning how to leverage these tools. So, why wait? Give your Excel workspace a makeover and experience the benefits of working in full screen mode today!

Matt Jacobs Support Your Tech

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related Posts

  • How to Exit Full Screen in Mozilla Firefox: A Step-by-Step Guide
  • How to Make Excel Full Screen: A Step-by-Step Guide for Distraction-Free Work
  • How to Exit Full Screen Windows 11: Simple Steps for All Users
  • How to Exit Full Screen in Excel: A Simple Step-by-Step Guide
  • How to Go Full Screen on Windows 11: A Step-by-Step Guide
  • How to Reset Workspace in Photoshop CS5: A Step-by-Step Guide
  • How to Exit Full Screen Game on Windows 11: A Step-by-Step Guide
  • How to Exit Full Screen Windows 11: A Step-by-Step Guide
  • What is Excel Compatibility Mode?
  • How to Exit Full Screen View in Excel (2024 Guide): A Step-by-Step Tutorial
  • How to Make Page Layout the Default View in Excel 2010: A Step-by-Step Guide
  • How to make GTA 5 full screen on Windows 11: A step-by-step guide
  • How to Enter Full Screen on Windows 11: Simple Steps and Tips
  • How to Use Google Docs Dark Mode
  • How to Switch Between Full Featured and Basic Mode in Microsoft Word
  • SharePoint Accessibility: Desktop App Availability Explored
  • How to Open ICA File on Windows 11: A Step-by-Step Guide
  • How to Exit ASUS BIOS Utility EZ Mode Windows 11: A Step-by-Step Guide

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time. Read our Privacy Policy

How to Activate the Full Screen in Excel

- Written by Puneet

Excel’s Full-Screen Mode can help you to focus on your data without the distraction of the Ribbon and other interface elements. This mode can be particularly useful for presenting data or when working on a large worksheet.

Activate Full-Screen Mode from Ribbon in Excel

To activate Full-Screen mode in Excel, allowing you to view your workbook without the Ribbon, status bar, and formula bar, follow these steps.

Quick Steps

  • First, move your cursor to the right of the screen.
  • Now, click on the down arrow from the ribbon.
  • After that, move your cursor to the “Full-screen mode”.
  • In the end, click on the option to activate the screen mode.

When you click on it, your Excel will convert into a full screen mode where it hides the ribbon and quick access toolbar.

And if you also want to hide the formula bar and headers, you can go to the View Tab:

  • Go to the View Tab : First, click on the “View” tab on the Ribbon to access view options.
  • Find the Workbook Views Group : Look for the “Workbook Views” group within the View tab.
  • Click on “Full Screen” : In the Workbook Views group, click on “Full Screen” to enter Full-Screen Mode

To exit Full-Screen Mode, you can press the “Esc” key on your keyboard.

Important Note : Full-screen mode applies to the current workbook, not the entire Excel application.

For Older Versions of Excel (Before 2013)

If you’re using an older version of Excel, where the Full-Screen command is not directly available in the Ribbon, you might not find this option readily accessible from the Ribbon.

  • Minimize the Ribbon : Double-click any of the tab names (like “Home,” “Insert,” etc.) or right-click on the Ribbon and select “Minimize the Ribbon.”
  • Hide Status Bar : Right-click on the status bar at the bottom of the Excel window and uncheck the “Status Bar” option to hide it.
  • Hide Formula Bar : Go to View > Show and uncheck “Formula Bar” to hide it.

Adding Full-Screen Options Button to Quick Access Toolbar

You can also add a button to the quick access toolbar .

  • Go to the File Tab > Options > Quick Access Toolbar.
  • After that, select “All Commands” from “Choose Commands from”.
  • Select “Full Screen” from the list and click Add.
  • In the end, click OK to add the button to the quick access toolbar.

Once you click OK, it will add a button on the quick access toolbar.

The full-screen mode with this button slightly differs from the first options we learned above. And to deactivate this full-screen mode, you can use the Esc Key.

Using a Keyboard Shortcut for Full-Screen Mode

You can also use the keyboard shortcut Ctrl + Shift + F1 . Once you press this keyboard shortcut, it will activate the full-screen mode. And you can use the same shortcut key to return to the normal mode.

Benefits of Full Screen Mode in Excel

Using Full Screen Mode in Excel offers several benefits:

  • Maximizes Workspace : Full-Screen Mode removes the Ribbon, status bar, and potentially other interface elements, maximizing the available screen space for viewing data.
  • Enhanced Focus : By hiding most of the Excel interface, Full Screen Mode helps minimize distractions, allowing you to focus more on the data and tasks.
  • Improved Data Presentation : When using Excel to present data in meetings or to a group, Full Screen Mode provides a cleaner and more professional look by removing unnecessary interface elements.
  • Easier Navigation : With more of the worksheet visible on the screen, it’s easier to scroll through data, review large tables, and analyze charts. This can be particularly helpful during data exploration and when comparing worksheet sections.
  • Better Use of Smaller Displays : Users working on laptops or monitors with limited screen size can benefit significantly from Full Screen Mode, as it optimizes the available display area for Excel, making the best use of a smaller workspace.

tips.net

  •  >  Excel Tips
  •  >  Editing

presentation mode for excel

Viewing Your Work Full-Screen

presentation mode for excel

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.)

presentation mode for excel

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

Scanning and Fixing System Files

Is your system running a bit flakey at times? If you think the culprit might be a problem with some of your system files, ...

Selecting a Language

Need to format a paragraph (or some selected text) so that it is a language other than English? You can do so easily by ...

Entering or Importing Times without Colons

Enter a time into a cell and you normally include a colon between the hours and minutes. If you want to skip that pesky ...

presentation mode for excel

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More ExcelTips (ribbon)

Limiting the Scope of the Undo Command

As you make edits in Excel, the program remembers your actions so that you can later undo them. If you have multiple ...

Getting Rid of Everything Except Numbers

Got some numbers and letters mixed up in the same cell? You may need to get rid of those letters so you are left with ...

Numbering Filtered Rows

When you filter rows in your data, you may want to later number those rows. This tip provides a variety 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 seven less than 7?

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.

IMAGES

  1. TECH-017

    presentation mode for excel

  2. 11 Best Excel Presentation Tips in 2021

    presentation mode for excel

  3. How to insert Excel data into a Powerpoint presentation

    presentation mode for excel

  4. Creating a PowerPoint Presentation using Microsoft Excel

    presentation mode for excel

  5. Automated presentations: linking of Excel data to PowerPoint

    presentation mode for excel

  6. How to create your presentation using Excel?

    presentation mode for excel

VIDEO

  1. TECH-017

  2. PowerPoint 2016

  3. Viewing Excel Worksheets In Presentations

  4. How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part I]

  5. Excel + PowerPoint Integration: Full Tutorial

  6. Statistics in Excel Tutorial 1.1. Descriptive Statistics using Microsoft Excel