Action Shortcut Select all objects Select one object, then press Command-A Deselect all objects Select one object, then press Shift-Command-A Select objects by dragging Drag from a blank part of the sheet around objects.

A number of people in my office have been asking me how they can easily switch between worksheets in Excel using their keyboards rather than having to click on an individual sheet and this article will addresses that issue. This may sound lazy to someone who does not use Excel very often, but when you’re a manager and have an Excel spreadsheet in front of you with 50 tabs, that little mouse pointer can start to be a real pain! Anyway, it’s always good to know shortcuts if you can. I’ve been in the situation numerous times where my touch pad died and I didn’t have a mouse laying around. Knowing some slick keyboard shortcuts can make the difference between getting some work done and taking a coffee break. Switch Between Worksheets in Excel So in order to move through sheets or tabs in an Excel workbook using the keyboard, simply press and hold CTRL and then press the PgUp or PgDn buttons to move from right-to-left or left-to-right!

Working on Excel 2008 for Mac 10.2.2.5. 'Find/Replace' doesn't include 'Options' for merged cells. I am NOT the creator of the spreadsheet. Has 1900 rows, 28 columns. Have looked, can't find the cells. Clear merged cells in excel. Merging combines two or more cells to create a new, larger cell. This is a great way to create a label that spans several columns. If Merge & Center is disabled, ensure that you’re not editing a cell—and the cells you want to merge aren’t formatted as an Excel table. This Excel tutorial explains how to merge cells in Excel 2011 for Mac (with screenshots and step-by-step instructions). Check the 'Merge cells' checkbox. Click on the OK button. Now when you return to the spreadsheet, you will find your selected cells merged into a single cell.

` is the key on top of Tab key, so it's similar to Command ⌘ Tab shortcut. On other language: Go to System Preferences -> Keyboard -> Shortcuts -> on the left menu, select Keyboard -> on the right menu, select Move focus to next window.