Excel is a powerful tool, which can save your hours, if you know how to use it correctly. We have compiled some basic but very useful tips for beginner excel users.
1.Insert & delete Rows with Keyboard shortcut
To insert a new row between the existing rows, use this keyboard shortcut. Suppose you want to insert row between 6 & 7
Place the cursor cell A7 then hit Sift & Space, entire row will be selected, then hit Ctrl & ‘+’ (Ctrl & plus). A new row will be inserted. [Don’t use &, it just mean, press two keys together]
To delete the row first select the row by Shift & Space then hit Ctrl & ‘-‘ (Ctrl & minus)
Similarly, to insert new column, select the column by Ctrl & Space and then Ctrl & +
2.Using Format Painter
In the following table, suppose you want to format ‘Delhi’ and Bangalore with the same formatting as in ‘Delhi’ in first row. Keep your cursor on that cell and double click on format painter and now click on ‘Delhi’ and ‘Bangalore’ one by one.
3.Wrap Text
Use Wrap Text to wrap the content of the cell within the cell only. The row height will be adjusted automatically.
4.Merge Cells
5.Freeze Panes
6.Sorting data
By this option, you can short the data say, alphabetically, increasing order, decreasing order or any other parameter you would like.
7.Filter the data
By this option you can filter your data. Suppose, you want to filter the accounts having City as Delhi only. Select all the data and click on filter. Then click the dropdown on City and select Delhi. See result.
8.Inserting Comments
To make notes, you can insert the comments to any cell, which are not printed by default but you can view it anytime. [you can also print them you want].
To insert comment, just right click on the cell and click ‘Insert Comment’
9.Change your data to beautiful table
Just click on ‘Table’ under ‘Insert’ Tab, this will convert your data into a colourful, sortable table with filters. You can change the colours and style.
If you have any questions or you want more tips to use excel in a better way, please submit your views in comment box below.
As per AIBOC Circular dated 13.09.2023, the officers’ associations today, submitted a Supplementary Charter of…
Wage revision for bankers is due since November 2022, which is to be finalized through…
DA for Bankers is expected to increase for the quarter May 2023 to July 2023.…
If you're a banker, you know that staying up-to-date on industry trends and best practices…
DA for Bankers is increased for the quarter February 2023 to April 2023. CPI data…
12 Bipartite Settlement for revision of bank employees' salary and service conditions is due from…