How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
53785
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

What is the shortcut to fix a cell in excel $

Customer Question

What is the shortcut to fix a cell in excel "$"
Submitted: 8 years ago.
Category: Mac
Expert:  Bob Cook replied 8 years ago.
Some of my favorites are

Ctrl-$ for currency format. Works on Mac
Ctrl-% for perfentage. Works on Mac
Ctrl-Shift-Arrow. Select to the rigth

Ctrl-PgUp navigates through worksheets
Ctrl-PgDn navigates through worksheets.
Ctrl-Minus is Delect
Ctrl-Shift-Plus is Insert
Ctrl-* is fill in
Shift-Space selects a row
Ctrl-Plus inserts a row
Ctrl-Minus deletes a row

Is that the question you were asking?
Customer: replied 8 years ago.
What is the equivalent for F4 on a PC on a Mac????
Expert:  Bob Cook replied 8 years ago.
Redo is mapped to APPLE Y
Customer: replied 8 years ago.
Sorry I meant to say F4 in excel for PC which locks that cell, what is the equivalent for MAC, thanks!
Expert:  Bob Cook replied 8 years ago.
The only way I know how to lock cells is FORMAT - CELLS - PROTECTION then click the lock box.

The F4 on my PC version of Excel repeats the last instruction .
Expert:  John D replied 8 years ago.

Hi,

 

I think what you are looking for is AppleKey + T

 

Hope this helps.

 

Customer: replied 8 years ago.
Yes!!! Thanks much! My other question is how to get into the formula bar without having to click with the mouse? In a PC its F2
Expert:  John D replied 8 years ago.

Glad to know that.

 

To enter the edit mode on Macs try Ctrl - u (may not work on all keyboards)

 

Hope this helps.

John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience: Worked on Macs and PC's for 20+ years.
John D and 2 other Mac Specialists are ready to help you
Customer: replied 8 years ago.
Thank you so much!
Expert:  John D replied 8 years ago.

You are welcome. Glad to help.