How to set your Excel options to only create a single sheet

excel tips

Welcome to your weekly 3 tip Friday update, it’s just a short dose of Excel help before you start the weekend. Each week we’ll cover a tip, a shortcut and a function - making it super easy for you to get better at Excel. 

A quick win you can learn today - 

When you open Excel, 3 blank sheets are created by default. If your use of Excel is anything like mine - this can be annoying, in most cases I only need 1 sheet. You can set your Excel options to only create a single sheet in new files by going to File -> Options and change the ‘Include this many sheets’ option to the number of sheets you’d like.

SheetsShot.png

A keyboard shortcut I'm adding to my list - 

Ctrl + A is a pretty common (and useful!) keyboard shortcut, but I’m always surprised to find how few people know it! Use Ctrl + A to select all of the cells in the current table or sheet.

A function I've found super useful this week - 

Standard deviation is a useful mathematical tool to quantify the variation of a data set - for example if a set of figures are closely bunched together spread out.  The smaller the standard deviation, the more closely bunched together the data is. 

The STDEV function allows an easy calculation of the standard deviation of a data set, and it’s easy to use too. Just type =STDEV( followed by the range you want to measure.

Check out more Excel worksheet functions categorized by their functionality here!

Until next time, good luck with your Excel endeavours.

- Martyn

East Lothian, Scotland

September 2018

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit