Top 15 Excel Tips Which You Must
Know.
Excel codename is Odyssey is a
software program through which we are capable to create and edit spreadsheets.
In spreadsheet we can do a lot of things as we can create payroll, balance of
check book, organize a large amount of data, and this all is done by adding,
subtracting , multiplying things.
Excel is provided by Microsoft ,in a
package called “Microsoft Office”. Many vendors are also their in market which
provides excel spreadsheets.
These are some tips which makes your
work easy when you are working on Excel Sheets.
1) F2- This
function key is used to edit the selected cell in a spreadsheet.
2)
F5 – Through this function key we can go
to a specific cell. For example – C7.
3) F7 – This
function key is used to spell check for a selected text or document.
4)
F11 – Through this function key we can
create chart.
5) Ctrl + Shift + ; - This combination of keys can be used to enter the current time.
6)
Ctrl + ; - This combination of keys can be used
to enter the current date.
7) Alt + Shift + F1 - This combination of keys can be used to insert new worksheet.
8)
Shift + F3 - This combination of keys can be used
to open the excel sheet formula window.
9) Shift + F5 - This
combination of keys can be used to bring up search box.
10)
Ctrl + A - This combination of keys can be used
to select all contents of the worksheet.
11)
Ctrl + B - This combination of keys can be used
to bold selected selection.
12)
Ctrl + I - This combination of keys can be used
to Italic selected selection.
13)
Ctrl + k - This combination of keys can be used
to insert link.
14)
Ctrl + U - This combination of keys can be used
to underline highlighted selection.
15)
Ctrl + Z - This combination of keys can be used
to undo last action.
No comments:
Post a Comment