Re: Modifying cells in excel short cut table defined


George B
 

Great help greg, just a thought you should of done the key strokes as cap
letters so they were red each and not as words.

Thanks so much for the list it is great

-----Original Message-----
From: Jfw [mailto:jfw-bounces@lists.the-jdh.com] On Behalf Of Greg Nickel
via Jfw
Sent: Wednesday, December 17, 2014 14:19
To: Jfw@lists.the-jdh.com
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
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

Join main@jfw.groups.io to automatically receive all group messages.