Making Columns Wider & Rows Taller Making A Column Wide Enough To Fit Everything In
Move the cursor over the column letter
Move the cursor right until it changes to a cross arrow (shown below)
Double click The Column will automatically adjust
Making A Row Tall Enough To Fit Everything In
Move the cursor over the row number
Move the cursor down until it changes to a cross arrow (shown below)
Double click The row will automatically adjust
Adjusting The Row Or Column Manually
Move the cursor over the row number or column letter
Move the cursor down or right until it changes to a cross arrow
 or
Click and drag to adjust
Adjusting More Than One Row Or Column At A Time
Select the row or columns
Move the cursor down or right until it changes to a cross arrow
or
Click and drag to adjust
Select the whole spreadsheet Click on the square shown below
Move the cursor down or right until it changes to a cross arrow
or
Click and drag or
Double click to adjust
Dates & Times
The NOW( ) function can be used to 'date stamp' a worksheet. Not only will it insert the date, but it will update every time you use or print the worksheet.
Select cell
Click on cell to contain date stamp
Type the formula “=NOW( )” Without the “”
Or Use Paste Function for the function
Press Return Or click on the tick
The date and time will now be placed in the cell. To change the look of this:
Format Menu: Cells
Click on Number Tab The Number box will appear
Click on 'Date' (or 'Time') in 'Category' column
Click on date format required
Click on 'OK'
Pre-defined Date & Time Formats
In Excel you don't have to use a special format. Dates and times typed in any of the following formats are allowed:
m/d/yy 12/24/95
d-mmm-yy 24-Dec-95
d-mmm 24-Dec
mmm-yy Dec-95
h:mm AM/PM 9:45 PM
h:mm:ss AM/PM 9:45:15 PM
h:mm 21:45
h:mm:ss 21:45:15
m/d/yy h:mm 12/24/95 21:45
Date Shortcut: For Fixed Dates
You can insert the date in the correct format quickly with the following keys.
CTRL ; The date is inserted in the current cell.
NOTE : This will insert the date, not the date code. This means that tomorrow when you look at the worksheet it will still have today's date in (which might be what you want!)
Adding Lines And Borders Adding Borders To A Range Quickly
Select the cells to put an outline border around
Click on the downward arrow next to the Borders Icon 
Click on the type of border you want from the selection
 Repeating A Border Style
When you select a border style from the drop down list, it then becomes the borders icon. To use it again click select the range to change and click on the button instead of the downward arrow
Tearing Off The Border Toolbar!
If you intend to use the borders toolbar a lot then you can tear it off and leave it on you worksheet, close to where you are working
Click on the downward arrow on the borders icon.
Click and drag down on the small bar at the top.
The Borders tool bar floats.
To remove the Border toolbar click on the small  l button at the top right of it.
Adding Other Borders
You are not restricted to the borders on the toolbar. You can define any collection of lines around a cell that you wish:
Select the cell(s) to change
Format Menu: Cells
Click on the Borders tab
Short Cuts To The Format Cells Box
Select the cells to change then...
CTRL + 1 or
Click the Right Mouse Button And Select Format Cells From The Pop-up Menu
Dostları ilə paylaş: |
