Excel Training – Page 45 – STL

I even like the sound of it “zoom control”…I was so used to working in whatever view is set up, and then scrolling across endlessly to find the data I wanted to view…and if that didn’t work…I squinted.

But I don’t have to. I discovered Zoooom control. I can access it using the Zoom control slider on the screen. It’s there all the time.

zoom-control-microsoft-excel-course — Found in the bottom right corner of your screen.

I can use the slider to move in and out of my worksheet, zoom in on a few cells to see the detail, and zoom out again when I’m done.

I can do the same by holding down the control key and using the roller in the middle of the mouse to zoom in and out.

Sometimes, we can miss out on the little things that make can make our work with Excel easier. A one day Microsoft Excel training course can allow you to zoom in on Excel’s possibilities (yeah, you see what I did there) and now I can zoom out (weeeeee).

Minor panic yesterday…I’d worked on an Excel file and quite possibly (you can take that as a yes) I hadn’t saved the changes. I was a bit distracted at the time and seemed to have forgotten the basic Save.

Excel is very forgiving like this. It has a way that you can recover unsaved work. Excel has it all figured out, with Versions.

So knowing that it is working with busy humans, Excel sets up auto-saving every so often (and it doesn’t even tell you that it’s doing it…it just keeps on going in the background).

So if you forget to save, you can access these auto saved versions of the worksheets. You can access any file you saved without closing, or view versions where you forgot to close the file (Excel automatically saves these as drafts). Now that is worth its weight in gold.

You need the File menu for this, and select Info and then, the Versions section.

file-versions-excel-courses — Recovering unsaved files – thanks Excel.

The screen shows the unsaved version, so I can now open the workbook. When I open it, it won’t replace the current version I have, so this is where I need to decide whether to replace the original with the current autosaved one, or not. Now, when I close the workbook, the autosaved version is deleted. Phew. Panic averted.

Recovering unsaved work is included on our excel course – it really can help remove the oh-oh moments.

Blog Categories