Are you in a browser Reply Tayo Johnson says: June 24, 2019 at 4:17 am Use Fn Cmd T, there you are.

One example is if I wanted to lock a cell, say for example A1.

I would put the dollar sign () in from of both the column and row number as follows: A1.

This still works in the Mac world if I enter it manually, but in the Windows version of Excel, there was a keyboard shortcut (highlight A1 in the formula bar and then press the F4 button) which would put the signs in for you.

It was only after poking around did I find out that the Mac keyboard shortcut equivalent is not F4, but Apple key T.

Other posts about scaling up businesses I Only Own One Pair Of Shoes How To Dramatically Increase Business Efficiency: 5-Step ARSAD Funnel Leave a Reply Cancel reply Your email address will not be published.

Required fields are marked Name Email Website Post Comment G Web says: March 12, 2009 at 10:54 am Apple Think Differently.this post definitely proves that.heheheheheh.there are two kinds of computer users those who have Macs and those that wish they do.I belong to the latter group.

Reply alwyn says: March 26, 2009 at 11:44 pm this was very helpful.

Thanks again Reply Alvin says: July 29, 2009 at 5:15 pm While I do know how that command functions, unfortunately I have no clue what its called Reply Liz says: August 16, 2009 at 7:15 pm New to mac, the excel program is driving me insane.

I want to ensure that I cant accidentally modify the contents of these cellsinterfere with the formula once Ive set it up (Im using a laptopit happens).

Is there a way of selecting columns and cells to keep the format from being changed Also, is the, erm, command key the same as the old Apple key I had a mac as a kidbut dont remember.

Thanks Reply Alvin says: August 16, 2009 at 11:32 pm Hey Liz, Im more of a Windows-guy, so I dont really know about the command key and old Apple key.

However, I do know that you can protect cells from being edited this can be found in the Format Protection menu in Windows Reply Jt says: September 10, 2009 at 9:04 pm Hey dude, U rock, I short of words to explain how much your tip has helped me.

Excel Command For New Row How To Protect Certain

Many thanks Reply Faith says: November 30, 2009 at 9:09 am Hi there Ive owned my very first IMac for two days now and I follow all the instructions I read on how to protect certain cells in one of our Excel spreadsheets (we easily did this when using Microsoft Excel on a PC) but the MAC version of Excel seems to only let you protect the whole sheet or nothing, there is not an option to just protect some of the cells.

Theres got to be a way, Ill just have to keep on searchin Any help would be greatly appreciated.

Reply Alvin says: November 30, 2009 at 10:48 am hey there maybe this would help Reply Faith says: November 30, 2009 at 5:36 pm Thanks, but this I had already tried when I made my post.

Didnt work at all for MAC but yes, this is how we had been doing it on our Microsoft PC.

Reply Amit says: January 29, 2010 at 6:20 am thanks for that.

Methinks Gates sabotaged it Reply Tyler says: February 15, 2011 at 1:37 pm Thanks, ditto Kalle.

This is just Microsofts way of getting back at Macs taking over.

Reply Brian says: February 22, 2011 at 12:45 am Anyone figure out how to edit a cell with a keyboard shortcut on Windows its F2 but for the life of me I cant find anything on the Mac equivalent.

Thanks for the solution to my ability to lock in a reference cell e.g.

Mac vs the Windows version of key stroke f4, Jim Reply Katie says: August 14, 2015 at 8:41 am I tried the command and T but it did not work.

Excel Command For New Row Code Or R

Im not a big Excel fan but this will patch up what I need to present until I get through some MATLAB code or R.

Thanks a ton. Reply MJ says: January 29, 2018 at 4:06 pm THANK YOU, YOU ARE AN ANGEL SENT FROM ABOVE Reply Anonymous says: April 7, 2018 at 11:19 am Thanks Reply GReat says: October 16, 2018 at 5:59 pm Great Thanks Reply Jamie says: April 22, 2019 at 1:20 pm When I select Command T a new screen appears as if that function opens a new window Any suggestions Reply Alvin Poh says: April 25, 2019 at 8:36 am Doesnt sound like youre in Excel.

Mac Excel Command For New Row