Excel

https://www.blogger.com/blogger.g?blogID=1455583216827712322#allposts
Saeedkhan
pressing the Shift + Spacebar keys once selects the section of the row containing the data;
pressing the Shift + Spacebar keys a second time selects the entire row.
NAVIGATING ROWS AND COLUMNS
Although using the mouse pointer to click on cells or to use the scroll bars, is always an option for moving around a worksheet, for large worksheets it can be quicker to navigate using the keyboard. Some commonly used key combinations include:

Ctrl + Down arrow – jump to the last row of a worksheet;

Ctrl + Up arrow – jump to the first row of a worksheet;

Ctrl + Right arrow – jump to the last column of a worksheet;

Ctrl + Left arrow – jump to the first column of a worksheet;

ADDING ROWS COLUMNS TO A WORKSHEET
The same keyboard key combination can be used for adding both columns and rows to a worksheet:

Ctrl + Shift + “+” (plus sign)
To add one rather than the other:

select the entire column to the right of the location for the new column;

select the entire row above the location for the new row.
Note: For keyboards with a Number Pad to the right of the regular keyboard, use the + sign there without the Shift key. The key combination becomes:

Ctrl + “+” (plus sign)
CITE

How to Quickly Sum Columns or Rows in Google Sheets

Add and Delete Rows and Columns in Excel

Limit Rows and Columns in Excel

Column and Row Headings

Sum Columns or Rows of Numbers With Excel’s SUM Function

Basic Microsoft Works Spreadsheets Tutorial

Hide and Unhide Columns and Rows in Excel

Cells

 

How to Select Rows, Columns, or Worksheets in Excel

The Magic Formula Bar (fx bar)

How to Multiply in Google Spreadsheets

Here’s How to Merge Cells in Excel and Google Spreadsheets

Here’s How to Add Up Columns or Rows of Numbers in Open Office Calc

Show or Hide Formulas in Excel and Google Sheets

Excel LOOKUP Function – Vector Form
Amit Kumar gayen prof nursery

Advertisements