Page up and down on mac excel

How to Use Microsoft Excel. Learn Online.
Contents:
  1. What is Scroll Lock in Excel?
  2. How To: F2 in Excel for Mac Update: November Microsoft Excel Tips • Excel Semi-Pro
  3. The Excel Keyboard Shortcut Cheat Sheet for PC and Mac users
  4. Excel Speed: 3 Keyboards Shortcuts worth Memorizing

Versions: , [add].

What is Scroll Lock in Excel?

Shortcuts published under Creative Common License where possible. Website: Copyright Terms of Use. A wiki-style reference database for keyboard shortcuts. Comments To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.

How To: F2 in Excel for Mac Update: November Microsoft Excel Tips • Excel Semi-Pro

You must select the row starting with the active cell. After pressing Return, move selection, select the direction you want to move in.

Use charts F11 Insert a new chart sheet. Happily, you don't have to.

MAC EXCEL 2011

Excel already provides a modicum of help, listing the parameters to a function when you type the opening parenthesis following its name. But that's not always enough of a clue. Let's take the example of one of Excel's powerful yet perplexing financial tools, AMORLINC, which when given five or six parameters returns the prorated linear depreciation of an asset for each accounting period. But what do they mean?

OK, this isn't a single keyboard shortcut, it's a whole family of them, but they all work on the same principle — and they're all in the row across the top of your keyboard, which makes them really handy if you want to change the presentation of your spreadsheet without picking up your mouse. Say hello to the number formatting shortcuts:. Windows users don't know how lucky they are, being able to navigate all the elements of a dialog box, including buttons and checkboxes, without a mouse by tabbing from one to another.

You can't do that on macOS, where tabbing just moves you from one text input field to another.

The Excel Keyboard Shortcut Cheat Sheet for PC and Mac users

Or rather, you can't do that on macOS by default. There is a way to turn on that Windows-like behavior — and there's even a keyboard shortcut for it. It's not part of Excel, though: It's part of macOS. The long way to do it is to go to the Apple menu and select System Preferences Now you can navigate dialog boxes without having to pick up your mouse or touch the trackpad.

To sum up this tour of useful keyboard shortcuts, let's conclude with one for what is probably the most commonly used Excel function: summing up a column. Excel looks down on rectangular selections that extend across multiple rows and columns.

How to scroll up/down on my MacBook laptop

Here are the latest Insider stories. More Insider Sign Out. Sign In Register. Sign Out Sign In Register.


  1. mac photo editor like photoshop;
  2. 224 Excel keyboard shortcuts for Windows and Mac.
  3. The Microsoft Office for Mac Keyboard Shortcuts Cheat Sheet?

Latest Insider. Check out the latest Insider stories here. More from the IDG Network. Microsoft Excel has a host of keyboard shortcuts that you can use to speed your work. All Slides. View all the formulas in an Excel worksheet at once. How to quickly draw a border around a cell in Excel.

How to quickly remove borders around cells in Excel.

Excel Speed: 3 Keyboards Shortcuts worth Memorizing

How to easily flip a column of data to a row in Excel. How to quickly select the current row or column in Excel.


  1. 12 keyboard shortcuts that will make you better at Excel?
  2. F2 in Excel for Mac?
  3. pdf to word mac free software?
  4. Edit the Active Cell in Excel for Mac.
  5. Keyboard shortcuts for working in a remote desktop Windows Machine from your MacBook – lallous' lab.
  6. 3 Replies to “Keyboard shortcuts for working in a remote desktop Windows Machine from your MacBook”?

How to format any object in Excel. How to get help building a formula in Excel. How to quickly format numbers in Excel. Summing up shortcuts in Excel. Share this Slideshow. Direct link:. See larger image. Or, in Excel's case, the keyboard shortcut. How to quickly draw a border around a cell in Excel Sometimes you want to draw a box around a result to call attention to it — but Excel offers so many different border styles, it's easy to become sidetracked. How to quickly remove borders around cells in Excel Oops: You or a colleague succumbed to the temptations of the Format Cells - Border dialog box see previous slide , with its cornucopia of line styles, colors, orientations and spacings, and your worksheet now looks like a Mondrian-Jackson Pollock mash-up.

Told you it was quick. How to easily flip a column of data to a row in Excel You distractedly type in a whole series of labels, then realize that you meant them to go across a row, and not down a column. How to quickly select the current row or column in Excel This is a quick one. How to format any object in Excel You selected something in Excel — a cell, a drawing, or a chart — and want to reformat it.

How to get help building a formula in Excel If there's one thing I learned at college, it's that there's no shame in looking it up. How to quickly format numbers in Excel OK, this isn't a single keyboard shortcut, it's a whole family of them, but they all work on the same principle — and they're all in the row across the top of your keyboard, which makes them really handy if you want to change the presentation of your spreadsheet without picking up your mouse.