A1 Home Shortcut On For Excel Mac Makes You

However, using Excel on a Mac makes you keenly aware that theres no Home button.

Tip: Sometimes you can delete the seemingly extra rows and columns outside your data range and it will reduce the file size.

Of course if you cant see cell A1 in the current window there is no Home button on the Mac to help you out.

This can be simple, or time-consuming depending upon size and shape of your worksheet.

Choose Tools Macro Visual Basic Editor, then choose View Immediate Window, and type activesheet.usedrange.select inside the immediate window and hit enter.

I pressed the u key on the keyboard, and consequently the keyboard combination is shown as Option Cmd u, as you can see in the screen shot.

Depending on the key, you may also include COMMAND, Control, Shift into your shortcut.).

Select the Cancel button on the Macro dialog box to make it disappear.

Meaning that some blank cells that are formatted might be included in the used range.

Most likely you will only want to deal with a range that has some actual values.

These examples are short and use the VBA FIND function to get the job done.

Any ActiveX controls (button, radio button, etc.) will not work on a Mac and have to be replaced by Form controls.

Most of the VBA environment is similar, but different enough it feels strange.

A1 Home Shortcut On For Excel Code Is The

Most of the VBA code is the same, but there seems to be some properties that dont exist on the MACs version of VBA.

Still, it would be nice if Microsoft would make the MAC version as much like the Windows version as possible in their next software update.

A1 Home Shortcut On Mac For Excel