Scribd
Upload
20 views4 pages

Excel Shortcuts and Formatting Tips

The document provides a series of keyboard shortcuts and formatting techniques for Excel, including methods for selecting data, inserting columns, and using the Format Painter. It also explains how to delete rows/columns and utilize the autofill feature for data entry. Additionally, it covers text wrapping and merging cells for better data presentation.

Uploaded by

galwinsamuel2001
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
20 views4 pages

Excel Shortcuts and Formatting Tips

The document provides a series of keyboard shortcuts and formatting techniques for Excel, including methods for selecting data, inserting columns, and using the Format Painter. It also explains how to delete rows/columns and utilize the autofill feature for data entry. Additionally, it covers text wrapping and merging cells for better data presentation.

Uploaded by

galwinsamuel2001
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Ctrl+arrow=last cell of continous data

CTrl+ shift+arrow= used to select datas as you move


along the way
Ctrl+A = select continous entire data
Ctrl+pg up/down move along sheets

Formating painter = Click the cell(Excel)/ 2 times for


multiple cell which format + Click Format Painter + Select
the cell which needs format painting and esc

New column will be inserted to the left by Right click on


the column and insert column.. Incase of row top of the
selection ooo

Data of the column/row can be deleted by right click on


the column/row or dragging + right click + delete/
Delete Key ooo
ooo
ooo
ooo
Index autofill

Excel Excel Excel


1

Wrap text
fits every
data in a
single cell
Select and Merge cells
Hosanna
Feeded Satisfied Gospel
jjj 1 1 mon
kmkm 1 2 tue
j kk 1 3 wed

Click
bottom '+'
knmopmop 1 4 thu and drag
n jkk 1 5 fri
bun 6 sat
eae 7
efseefs 8
dfs 9
dfg 10
fg 11
fg 12
fg 13
esefes 14
et 15
efseefs 16
efseefs 17 Double click the bottom '+' by typing the numbers
e 18 Autofills the data till the end

fhngfhnfgh
fg
fgf
Monday January Jan 2001
Tuesday February Feb 2001
WednesdaMarch Mar 2001

Thursday April Apr 2001


Friday May May 2001
Saturday June Jun 2001
Sunday July Jul 2001
Monday August Aug 2001
Tuesday SeptemberSep 2001
WednesdaOctober Oct 2001
Thursday November
December
January
February
March
April
May
June

You might also like