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 : :

Updated contrive page

Daily updated photo blog with intense men

Reminder

Порно фото галереи, более 500 тысяч фотограф&#

Блог с женскими секс-историями

Протестируй н

Лучшие сериал

Right-minded started fresh occupation

Cheap NFL Jerseys

Список 2017 лучши

Pictures from collective networks

Unshackle galleries

смотреть лучш

Recent install

casual dating site philippines

Callow Project

Callow Poke out

Stooday

Loose galleries

Daily gay photos usage

Free galleries

Лучшие докуме

Steve Alten - MEG, Books 1-5 (Meg, The Trench, Primal Waters, Hell's Aquarium, Nightstalkers) - eBooks [Isohunt.to]

Бизнес выгодн

Cheap Vintage Jerseys Sale

С двумя блочн

Adobe Photoshop CS6 13.0 Final (English Japanese) Mac Os X [Chi

My brand-new website

Matured placement

New spot




SoftwareTipsandTricks, All Rights Reserved.