SoftwareTipsandTricks.com
Home Forums Windows 7 Security Tips
Forums

Windows 7
Windows Vista
Windows XP

Security Tips
Troubleshooting
Keyboard Shortcuts
Encyclopedia


Drivers

Internet Terms
Computer Terms

File Extensions (75)
File Extensions (15K+)

Startup Applications
Necessary Files
Useless Files
At Your Option Files
Dangerous Files
Browser Objects

DLL Files
SYS Files
INF Files
OCX Files
VXD Files

Virus Database
Virus Warnings

Easter Eggs
Tips and Tricks
Articles
Hot Downloads


Privacy Policy
Contact Us







  Microsoft Excel

Fill in a Series of Dates or Numbers
You can easily fill a series of cells with consecutive dates in Excel. First click a cell and enter the starting date in default date format (month/date/year). More the mouse pointer to the bottom right of the cell to get a small cross called Fill Handle. Click and drag across the cells you want to fill with the dates. To customize the series, drag with the right mouse button and click on Series.

Rid Yourself of Fine Lines
To remove cell gridlines from a spreadsheet, Select Options from the Tools menu and click on the View tab. Under the Window options, uncheck the Gridlines box and click OK. the gridlines removed from your spreadsheet.

Open Specific Spreadsheets at Start-Up
Excel can be started up with spreadsheets that you most frequently use. To do this, first open the spreadsheet you want to open at startup. Then click on File > Save As and locate the XLStart folder within the \Program files\Microsoft Office\Office folder. click the Save button to save this file in the folder. Next time you start Excel, this spreadsheet will automatically open.

Fractions or Decimals?
Get better accuracy in fractions than Excel normally gives. you can specify the number of digits the denominator and numerator of a fraction can have. Simple click on the cell that has the value and click on Format > Cells. Under the Number panel, select Fraction from the Category lest. Then select the required accuracy from the Type list.

Enter More than one line of Data in a Cell
Entering more than one line of text in a cell is as simple as pressing Alt+Enter to make a new line inside the cell. if you don't want line breads, you can have multiple lines in a given cell is by clicking cells from the Format menu. Click on the Alignment tab and enable Wrap Text. Entering data wider than the column width will then wrap on the next line.

Protect Cells From Data Entry
Keeping certain cells in Excel spreadsheets from being modified is easy. Select the cells you wish to allow writing to. Non-adjacent cells can be selected by clicking on them while keeping the Ctrl key pressed. After selecting the cells, click Format > Cells. Under the Protection tab, uncheck the Locked checkbox and click OK. Next, click on Tools > Protection and select protect Sheet. You will be prompted for a password that is optional. Click OK and save the spreadsheet. Now only the unlocked cells and be modified. Trying to overwrite locked cells result in an alert message being displayed. If you want to protect only a few cells, it would be good idea to select the entire worksheet and use the Ctrl key to deselect only the cells you want to protect before unlocking them.

Give your Worksheet a Background
Add a background image to your spreadsheet. click on Format > Sheet > Background. Browse for the image you want and click Open to select it. The given image will tile to fit the worksheet.

Don't Lose Sight of Your Headings
Keeping the row and/or column heading on your spreadsheet however you scroll can definitely improve readability of your spreadsheet. Drag the split box next to the scrollbars to the row and/or column that holds the headings. Click on Window > Freeze Panes. The tow and/or column will now be locked and remain visible thought the rest of the spreadsheet.

Change the Cursor's Default Direction
When you press the Enter key in a cell, Excel by default moves the cursor below it. to change this, open Tools > Options and click on the Edit tab. change the direction of the selection movement from the drop-down list titled Move Selection after Entry.
 


 

: : Recent posts at Forums : :

My new website

My brand-new website

Further lodgings bellhop for throw

Quotidian updated photo blog with boiling men

Stared fashionable prepare

Assignment servant moved

gaxnmg The urban Indian consumer is ruthless in making choices

Grown up galleries

Callow Poke out

Rejuvenated net work

Very recently started supplementary project

Renewed install

My supplementary website

Mature galleries

My unfamiliar website

Very recently started untrodden occupation

Grown up site

Sexual pictures

Mature placement

Common updated photo blog with fiery men

Mature galleries

lpywfu Phillips Van Heusen Bonds Yield 28X PVH Dividend

New Project

My chill describe

My new effect

My chill project

Delivered matured galleries

Public pictures

Unique home bellhop instead of throw

My brand-new website




SoftwareTipsandTricks, All Rights Reserved.