Microsoft Excel, three (3) Quick working skill tips.

How would we manage without Excel? But do we know all the useful tips that are available, to make using it easier? Here are thre...

How would we manage without Excel? But do we know all the useful tips that are available, to make using it easier?

Here are three more, which we hope you’ll find useful: colour shading alternate rows, adding a drop-down list, and doing maths without using formulas.

All these tips are based on Microsoft Office Excel 2010 (Windows) but other Excel versions offer the same or similar functionality. (Menus and performance may vary.)

Tip 1: Colour-shading alternate rows

Ever wondered how to make green-banded computer paper on screen? It makes lengthy lists much easier to read.

Here's how:
  1. Highlight the range of cells or rows or columns that you want to format.
  2. Click Insert, then Table.
  3. A box will pop up, called Create Table. Click OK.
  4. Then just click the Design button, to choose the colours and pattern you want. Click at the bottom of the drop down list to see the full range of colours available. If you want to design your own, click New Table Style and do some experimenting!
The alternate row shading will automatically continue, even if you insert or delete rows within the original range.

If you want to delete the shading, click Clear, right at the bottom of the Design drop down list.

Tip 2: Add a drop-down list

Inserting a drop-down list into a cell makes worksheets more professional and ensures that correct data is entered.

If you want to insert a drop-down list with the months of the year, for example, here's what you do:
  1. Enter the items that you want on your drop-down list into a list on the worksheet, one item per cell. In this example, we will assume that the month names start in cell G1 and extend down to G12 (12 months, one per cell), but they can be anywhere on the worksheet. This group of cells (such as G1 to G12) is called a range.
  2. Select the cell that will contain the drop-down list. If you'd like more than one cell to display the same list, just select them all now rather than setting them up one at a time. (To select a range, click and drag; to select non-adjacent cells, hold down Ctrl while you click.)
  3. Choose Data, Validation to display the Data Validation dialogue box.
  4. Click the Settings tab.
  5. In the Allow field, select List.
  6. In the Source field, specify the range of cells that contains the list items. In this example, the items are in cells G1 to G12, so type =G1:G12 into the field.
  7. Click OK.
You'll now see a drop-down arrow whenever any of the drop-down cells you just defined is "active" (selected and waiting for input). Click the arrow and choose a month from the list.

Tip 3: Maths without using formulas

If you want to do maths in an Excel sheet, you don't have to be able to write formulas. Instead, you can use the Paste Function dialogue box, which allows you to perform basic maths operations, without using formulas.

Supposing you have figures such as prices in an Excel worksheet, and you want to increase all the prices by 7%.

Here's what you do:
  1. Enter 1.07 into any blank cell – this is the "multiplier" which will increase the price by 7%. If the prices were to increase by 25%, you would type in 1.25
  2. Now select that same cell and choose Edit, Copy or press Ctrl-C.
  3. Select the range of cells which you want to change, and choose Edit, Paste Special to display the Paste Special dialogue box.
  4. Choose the Multiply option and click OK.
Your prices will now be changed. Delete the cell into which you wrote your 1.07 multiplier.

We hope you found these tips useful!



Acronyms,1,Ads Ready,1,Adsense,1,Adserver,1,airtel,2,android,22,Apps,4,Auto Loader,19,backup,1,Bank,1,BB10,1,better,1,bios,1,blackberry,24,Blogger,11,blogger jquery,12,Blogger Template,3,blogger tips,12,Blogger Widget/Gadget,13,Bluetooth,1,BOIS Update,1,browser,2,Bug,1,business,3,CAD,1,capability,1,Career Development,2,Celebrate,1,chat,1,cloud computing,1,code,1,comment,2,computer,13,crack,17,crash,1,css,3,cure,1,CV,18,data,2,delete,1,Diamond Bank,2,download,32,email,6,ESPN,1,etisalat,2,Facebook,2,Feedburner,1,Firmware,3,Flash File,27,Flash Games,3,Flashing,3,For Seniors,2,free-up space,1,Freebies and Giveaways,2,FTP,1,Galaxy,2,games,5,glo,2,good,1,Google,8,Google Affiliate,1,Google Drive,1,Google Photos,1,Google Play Store,3,Google+.,1,great,1,GTA,4,guide,3,hacks,7,handle,1,Hard drive,2,HDD,1,how to,10,HTC,2,html,1,Huawei,1,ict,4,India,1,INEC,1,Infinity Best,1,Innovation,1,Intel,1,internet,6,internet explorer,1,iOS,2,ipad,4,iphone,7,Itel,1,java script,6,Jetpack,1,keyboard,8,know,3,Label,3,Laptop,1,Learning,12,LG,2,Lollipop,2,Mac,2,Management,1,Marriage,1,Mediafire,1,meeting,1,message,12,Microsoft,5,Microsoft excel,2,mobile,7,Mobile Phones Specifications,1,mobility,2,money,1,Motorola,1,Movie,1,Mozilla Firerfox,1,MS Word,1,MTK,2,mtn,4,music,1,need,1,Networking,1,NOBLE NOKIA INFO,9,Nokia,4,notebook,1,passwords,1,PayDirect,1,PayPal,1,PC,7,PC Games,45,PC mgazine,6,PC Tricks,3,pc-crash,1,PDF,1,Personal Productivity,4,Phone,3,photo shop,1,Play Station,9,Plugin,1,post,2,Premium Blogger Template,1,protect,3,ProtectTool,1,Racing Game,2,reasons,1,Responsive,1,Root,2,sagem,1,samsung,11,save,1,secrets,1,secure,4,security,9,security Enhancements,5,Server,1,shell-coding,1,shortcut,21,Simple Server,1,SmartsmsSolutions,2,SMS,6,social community,3,Sony,2,Spreadtrum,1,SSD,1,steps,1,Stock Rom,2,Symbian,1,Sync,2,Tablet PC,3,Talent,1,TECH_WORLD,2,Techniques,3,technology,3,technology tips,26,Tecno,7,template hacks,1,Theme,1,tips,19,transmissions,1,Tutorial,3,tutorials,28,types,1,USB Driver,1,users,1,Video,1,Virus,1,Visa Card,1,Volcano Box,8,Vote,1,WAP WORLD,8,Whatsapp,1,windows,11,Windows 10,2,Windows 7,1,Windows 8,1,windows mobile,1,Windows Phone,2,Windows Phone Store,2,windows xp,5,word of life,11,Wordpress,3,work place skills,7,WPTouch Mobile Plugin,1,Xbox,2,zain,1,Zenith Bank,1,
NOBLE ICT EXPLOITS ZONE™: Microsoft Excel, three (3) Quick working skill tips.
Microsoft Excel, three (3) Quick working skill tips.
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy