Long ago, Excel offered a full screen mode. The Ribbon would completely disappear and you could get the maximum number of rows in the grid visible. The feature was removed in Excel 2013. Today, it is back! At least in beta. Take a look at how Full Screen Mode in Excel works.
Link to the old help topic about full screen mode: Switch to full or normal screen view in Excel
Link to the old help topic about full screen mode: Switch to full or normal screen view in Excel
Transcript of the video:
Full screen mode is back!
Back in the year 2019, I was looking for Excel Full Screen mode. I know that it used to be there.
It was a great way to get a maximum number of rows in the screen.
But it turns out that it was taken out all the way back in Excel 2013.
It's not a feature that I use a lot, since it had been six years until I went to look for it.
But the great news is that today, at least in beta, it's back. So right now, in this spreadsheet I can see down to row 37, and if I would minimize the ribbon to show only the ribbon tabs, I can see five more rows down to row 42.
But today there's an extra choice called Full Screen Mode.
And then I can see all the way down to row 46.
Now when you're in full screen mode, let's say that you would need to do something from the ribbon. I'll select these cells.
Use the three dots at the top right. Do any formatting that I might need to do.
And then when I click back to the grid. It returns to Full Screen mode.
The other amazing thing is that if I have two workbooks open and I'm put this one in full screen mode.
When I Ctrl+Tab to the other workbook, because this one doesn't need to be in full screen mode, the ribbon comes back. That's great.
To exit Full Screen Mode.
Go to the three dots and then use the same command that you use to get into full screen mode, this time choosing Always Show Ribbon.
Now I'm not going to pretend to be an expert on full screen mode.
But this Help topic reminded me that Ctrl+F1 was the shortcut key to get it.
Today Ctrl+F1 simply toggles between Show Tabs Only and Always Show The Ribbon.
Wouldn't it be nice if they added a third stop there that would go into full screen mode?
With our low production values we can get these videos out quickly.
If you want to know first, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
Well, thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Back in the year 2019, I was looking for Excel Full Screen mode. I know that it used to be there.
It was a great way to get a maximum number of rows in the screen.
But it turns out that it was taken out all the way back in Excel 2013.
It's not a feature that I use a lot, since it had been six years until I went to look for it.
But the great news is that today, at least in beta, it's back. So right now, in this spreadsheet I can see down to row 37, and if I would minimize the ribbon to show only the ribbon tabs, I can see five more rows down to row 42.
But today there's an extra choice called Full Screen Mode.
And then I can see all the way down to row 46.
Now when you're in full screen mode, let's say that you would need to do something from the ribbon. I'll select these cells.
Use the three dots at the top right. Do any formatting that I might need to do.
And then when I click back to the grid. It returns to Full Screen mode.
The other amazing thing is that if I have two workbooks open and I'm put this one in full screen mode.
When I Ctrl+Tab to the other workbook, because this one doesn't need to be in full screen mode, the ribbon comes back. That's great.
To exit Full Screen Mode.
Go to the three dots and then use the same command that you use to get into full screen mode, this time choosing Always Show Ribbon.
Now I'm not going to pretend to be an expert on full screen mode.
But this Help topic reminded me that Ctrl+F1 was the shortcut key to get it.
Today Ctrl+F1 simply toggles between Show Tabs Only and Always Show The Ribbon.
Wouldn't it be nice if they added a third stop there that would go into full screen mode?
With our low production values we can get these videos out quickly.
If you want to know first, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
Well, thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
