Skip to main content

MS Excel: 5 most useful shortcuts

 MS Excel: 5 Most useful shortcuts in Excel

1. Shift+space: This shortcut is used to select the single entire row. Hold down the shift key and use up/down arrows to select multiple rows.


2. Ctrl+ space: This shortcut can be time saving to select an entire column. Hold down the shift key and use left/right arrows to select multiple columns


3. Ctrl+T : This is used to quickly insert the table. It would ask where the data is for your table before creating the table.


4.Ctrl+9 : It can be used to hide rows in a worksheet.Note, hidden rows will not be printed.


5. Ctrl+0: This is helpful in hiding the columns in a worksheet. Note,hidden columns will not be printed. 


Click here to learn about Charts in Excel


Labels:

Comments

Post a Comment

Popular posts from this blog

MS Excel: To create charts

MS Excel: To create charts Ms Excel provides us different type of  charts which can be used according to the demand of data . Following type of charts can be used in ms excel: Pie Chart : It is used to express data in the form of percentage. Bar Chart:  It is used if we want to compare different values related to different categories.It runs horizontally as shown in fig below: Column chart: It is similar to Bar chart, however it runs vertically as shown in below diagram : Line Chart:   To show trend of  data over a span of time this kind of chart is used: Example: Lets us understand how to insert a chart in MS excel with an example. Consider we have a following data in the form of table and we want to display it in the form of chart. To display it in the form chart: Select the data Click on 'Column' under 'Insert' tab to select 'Column chart' Select the chart type to insert the chart 5 Most useful shortcuts in Excel
2 comments
Read more

MS Excel- For beginners

Lets learn basic things about MS- excel. Very first question, What is it? Ms-Excel is a spreadsheet program developed by Microsoft.Using this we can manipulate, format or calculate various arithmetic functions on data arranged in columns and rows.It looks like below: MS Excel basically consists of rows and columns. Rows :  Rows consists of horizontal lines, two parallel horizontal lines make a row as shown in fig below:   Here first row is selected. Number 1 represent row number 1 and similarly each number represents respective row number. Columns: Columns consists of vertical lines, two parallel vertical lines make a column as shown in fig below:   Each column is identified by a different alphabet as first column is marked as A.  Cell : A cell is a rectangular box which occurs as the result of intersections of rows and columns as shown below:               How to perform various arithmetic...
1 comment
Read more