Most Common Mac Shortcut Keys

The mac shortcut keys are slightly different to those on a PC. PC users press Ctrl and then a letter for example. Ctr and S to Save. A mac user can press the same keys or if that doesn’t work press Command S to Save. If you are using Microsoft Excel and you are working with Functions or Formulas you may from time to time find your self needing to perform and Absolute Cell referencing this is when you see a $ in front of the Letter $C or in front of the Number $6 or you may need it in front of both $C$6. On a PC you will press F4 as many times as you need until the dollar sign appears in front of the letter or number. However, on a MAC you will need to press Apple T this often baffles people for ages.

Mac Settings

The tricky thing with Mac shortcut keys is that you can change the settings so that F11, for example, performs a different instruction. That’s why on a PC you can select data to create a graph and Press F11 to produce a column graph onto a new sheet. However, if you do this on a Mac you will get a different instruction.

If you work in Excel with lists and you find yourself activating the Freeze Pane, Filters and Sorting, applying colour on every second row then try Format as Table Feature. The Format Painter is a great tool but most user don’t use it to its full potential refer to my previous blog on ” Apply Multiple Formatting Using Format Painter Microsoft Excel” .

Microsoft Office Small Group Training Sessions

AZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. We come to you. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. In our training sessions you are welcomed to bring examples of your work to class. We prefer it.

Call Now M 0414 417 059 visit

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s