Menu
Especially with the data in table format it is a difficult task to convert the columns of the table to rows along with the complete data. This article explains in step by step how to convert a column of an Excel 2010 sheet into row with pictures. Assume you have data in a table in an excel sheet as shown in the picture beside.
The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Pastecommand, which is driving me crazy so I decided to do something about it.
Default Excel F4 Keyboard Assignment in Excel for Mac
![How To Swap Rows Excel For Mac How To Swap Rows Excel For Mac](/uploads/1/2/5/8/125861764/719429935.gif)
There are four keyboard shortcuts assigned to the Paste command in Excel for Mac — Shift+Del, Control+V, F4, and Command+V.
Overkill, don’t you think? So I’m thinking the F4 button can be reassigned with no problems, unless, of course, you’re in the habit of using the F4 key for the Paste command.
Reassign the F4 button in Excel for Mac
- Select the Tools menu, and click Customize Keyboard…
- In the Categories: box select Edit
- In the Edit box, select Redo
- Select the Press new shortcut key: box
- Press the keyboard combination fn+F4 key (or just F4 key if you’ve setup the Mac function keys normally)
- Click Add
- Click OK to reassign the Paste command to the Redo command.
The Excel F4 button will now work with the Redo command, which is similar to how Excel for Windows is setup.
Note: You have to make this change to each version of Excel for Mac. For instance the above procedure was done in Excel 2011, but my Excel 2008 version of Excel for Mac wasn’t affected and has to be done separately.
No related posts.