Tips and Tricks #7
Schultz, John wrote on December 31, 1969 19:00 EST |
| This is a geat website to learn Excel tips from. I learned about shortcut I never knew existed. I think there is a high value for others if they would take a look at this website. |
Short cut - F2
mark wrote on December 31, 1969 19:00 EST |
Why not mention F2 - allowing you to alter text/entries within a cell rather than moving to the entry box at top
ps Great site! |
Shortcut to Center alignment?
Vishal wrote on December 31, 1969 19:00 EST |
| Can a cell in msecel be aligned without using mouse and ony using a keyboard shotrcut? |
euro sign
Effie wrote on December 31, 1969 19:00 EST |
Please can you tell me the short cut in excel for the euro sigh. eg. in word its ctrl alt with the E key.
thank you
Effie dreams@srh.forthnet.gr |
why does excel have 2 shortcuts to do the same thing
Lincoln wrote on December 31, 1969 19:00 EST |
| why does excel use crtl shift F1 and shift F11,, both perform the same function |
Changing default shortcuts
Heather wrote on December 31, 1969 19:00 EST |
I want to change the Ctrl + Page Down for "move to next sheet" to something I can do with my left hand, similar to Alt+Tab. How do you change the default shortcut keys?
heatherful@yahoo.com |
i don't understanding
famitha wrote on December 31, 1969 19:00 EST |
| sorry this execl keys i don't understanding so you teach me |
i don't understanding
famitha wrote on December 31, 1969 19:00 EST |
| sorry this execl keys i don't understanding so you teach me |
and i mean this in a nice way...
randi wrote on December 31, 1969 19:00 EST |
| for a geek like me this is a dream come true. |
and i mean this in a nice way...
randi wrote on December 31, 1969 19:00 EST |
| for a geek like me this is a dream come true. |
Hide Cell & Hide Collum
Tinku Malhotra wrote on December 31, 1969 19:00 EST |
Ctrl+9 Hide Cell & Shift+Ctrl+9 Unhide The cell .
Ctrl+0 Hide the Collum & Shift+Ctrl+0 Unhide The Collum |
Formula
Rajesh wrote on December 31, 1969 19:00 EST |
| Hi known few formula after seeing this site i learn few more. (Bzc learning is endless). I send this site to all my friends. |
Rename & Paste shrtcuts
M.Hussain wrote on December 31, 1969 19:00 EST |
| We can easly rename the cell value through F2. And also we can Paste through Enter press, Just Copy the data and where u want take data just press enter. |
Insert / Delete Row
Pratap K wrote on December 31, 1969 19:00 EST |
To insert a row, hit "Ctrl + '+'"
To delete a row, hit "Ctrl + '-'"
Cheers
Can anyone tell me how to get to a print preview in excel (only for selected text) |
excel formulas
rashid wrote on December 31, 1969 19:00 EST |
| i want to know how to enter the formulas on values in different conditions |
Excellent Tips for Beginners
Pranav wrote on December 31, 1969 19:00 EST |
| Great i am using excel since last 3 years, but during my last tenure of 1 year i have learned a lot shortcut and it makes wonders if applied. |
COPY OF PROPERITY OF ABOVE CELL
shailesh wrote on December 31, 1969 19:00 EST |
| CAN U GUIDE ME HOW 2 COPY THE ABOVE CELL PROPERITY BY SHORT CUT KEY |
Excellent Tips
Narinder Chauhan wrote on December 31, 1969 19:00 EST |
| Hi known few formula after seeing this site i learn few more. (Bzc learning is endless). |
Very Useful
Muhammad Ali wrote on December 31, 1969 19:00 EST |
| These are Very Useful Shorcut Keys for Key Board Users to working fast than using a Mouse. |
Hyperlink to the Validation
Sudarshan Kulkarni wrote on December 31, 1969 19:00 EST |
Hi, I am Sudarshan. I have one query can you insert Hyperlink to the validation field. that is there are more than 1 objects in the validation & if u want to link the particular object to the particular say worksheet. How you can do it.
Pls suggest
Thanx |
Copying Shortcut
Charles wrote on December 31, 1969 19:00 EST |
| Does anyone know of a shortcut to copy a formula down a column, other than having to highlight the whole column? |
Some shortcuts to my friends###$$$%%%***
Hi Friends This is Gopinath wrote on December 31, 1969 19:00 EST |
Ctl + Shift + 1 = two decimal point added in selected cell
use the number(with shift 1-10) and (without shift 1-10) is ur excel u the differs.
|
More shortcut keys
Marcello wrote on December 31, 1969 19:00 EST |
| If you go into Excel help and type in keyboard shortcuts, you will get a long list of shortcut keys. |
REquest for more shortcut keys
Sundeep Khemka wrote on December 31, 1969 19:00 EST |
Hi..
Is it possible that more shortcut keys be displayed in this site of yours. Thanks. |
Highlight Row or Column
Sumedh wrote on December 31, 1969 19:00 EST |
Highlight Row => "Shift" + Spacebar
Highlight Column => "Ctrl" + Spacebar |
excel short key required
Aamir wrote on December 31, 1969 19:00 EST |
how to convert from CAPITAL CASE INTO LOWER CASE
please reply soon
waiting |
Upper Case into Lower Case
Andy wrote on December 31, 1969 19:00 EST |
| use function lower() to convert into lowercase and function upper() to convert into uppercase |
ASSIGN A COLOR USING KEY BOARD SHOTCUT
K.T.BHANU PRATAP wrote on December 31, 1969 19:00 EST |
| Hey can any body mail me how to assign a color to a cell using keyboard short cut. I hopei can get the answer |
Short Cut for Format Painter
Jen wrote on December 31, 1969 19:00 EST |
Hey is there any short Cut of Format Painter ?
If there Please Do mail me or reply me .
Thanks In Advance.
Jen |
Short Cut Key
Gulzar Ahmad wrote on December 31, 1969 19:00 EST |
| I visited may sites for short cut keys but i think this is the best one. |
shortcut keys
pragati wrote on December 31, 1969 19:00 EST |
i want shortcut keys of font colour and column border, fill colour
|
Microsoft Excel VBA Programming for the Absolute Beginner
