I love these!  Great time saver.  Thank you for sharing.

Bob

-----Original Message-----
From: Jfw [mailto:[email protected]] On Behalf Of Greg Nickel
via Jfw
Sent: Wednesday, December 17, 2014 5:19 PM
To: [email protected]
Subject: Modifying cells in excel short cut table defined

All.

 

In case anyone wishes to create custom layouts in excel with addresses or
other items that need custom sizing here below is a list of the shortcuts to
get there and some others that I found useful along the way.  

 

Hold Alt when tapping the latter key strokes. (for excel 2007 and later)

 

Modifying cells in Excel

Protect sheet Alt HOP 

Lock cell: Alt HOL 

Format cells: Alt HOE

Adjust width: Alt HOW

Adjust height: Alt HOH

Auto fit Width: Alt HOI

Auto fit Height: Alt HOA

Default size: Alt HOD

Rename sheet: Alt HOR

Move or copy sheet: Alt HOM

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201412
17/bce55c40/attachment.html>
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com


_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

Reply via email to