Micro Soft Excel: 4 more tips to help you

Microsoft® Excel® [1] can do so much in terms of features, commands and functions. Some of those are complex while others – which ...

Microsoft® Excel® [1] can do so much in terms of features, commands and functions. Some of those are complex while others – which are actually very simple – are not known by all users. Want to easily sort and organize the data in a worksheet? Or protect your file from unauthorized viewing and changes? Hide rows or check for duplicate entries? All of these are possible.

Sorting groups of data and information
Excel can sort groups of data and information according to the criteria you tell it to follow, and in the order you desire – for example, alphabetical or chronological. Let’s say you have data entered as First name, Last name and Age: you can sort according to any of the three and then choose subsequent levels.

Highlight the group of cells you want to sort. If there is a header (title) row of cells, you can highlight those, too. Now, from the “Data” tab, choose “Sort” from the “Sort & Filter” group. If you have highlighted the header row, make sure “My data has headers” in the top-right corner is ticked off. Now choose the column you want to sort by and in which order (ascending/descending). Using our example of First name, Last name and Age, you can choose additional levels of sorting if, say, more than one person has the same “value” for either First name, Last name or Age.

No matter how complex the data, the same sorting rules, functions and features are applicable.

Password protecting an Excel workbook
Information security issues are on the rise and Excel is here to accommodate. For documents with sensitive information such as sales figures, you can add a password to prevent unauthorized opening of an Excel workbook.

From “File” or the “Office” button, choose “Save As”. In the “Save As” window, click on “Tools” in the bottom-left corner then “General Options”. Now enter your desired password and continue saving as normal. That document is now for authorized viewing only.

Hiding rows or columns
when it’s time to print your Excel worksheet, you may prefer some information not to be printed – for example, confidential information such as employee salaries or sales figures. To avoid printing specific rows or columns, just hide them before printing. (Hiding rows or columns can also simplify working with a complicated spreadsheet.)

To hide rows, select them by clicking the row numbers (left click and drag to select a block of rows; and remember, hold down “Ctrl” while clicking to select non-adjacent rows). Then right click one of the highlighted border row numbers and select “Hide”. Use the same procedure to hide columns, simply by right clicking a highlighted column letter and selecting “Hide”.

“Unhidden” is just as simple. To unhide rows or columns, highlight the entire spreadsheet by left clicking the box formed at the intersection of the row and column borders at the top left corner of the spreadsheet. Then right click a row or column border and select “Unhide”.

Spotting duplicate entries
Similar to how Word® can detect repeated words, Excel can spot repeated cell entries, but you have to tell it to. It’s a simple command.

Excel 2007 – which should be the norm by now – makes it simple. Select and highlight the cell range you want to check. In the “Home” tab and part of the “Styles” group, you’ll find “Conditional Formatting”. Click “Highlight Cells Rules” from its drop-down menu and then select “Duplicate Values”. Choose your desired formatting for how you want to identify duplicate entries – and you’re done!

[1] This article refers to the English version of Excel 2007.

Microsoft, Excel and Word are trademarks of the Microsoft group of companies.



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™: Micro Soft Excel: 4 more tips to help you
Micro Soft Excel: 4 more tips to help you
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