Excel Tip: Easy Way to Find Duplicate Items in a Column

Posted on 20. Apr, 2012 by in VirtualConnections Newsletter, Windows Resources/Tips

If you find yourself always merging worksheets of client data and know that there must be duplicates, here is an easy way to find those duplicate entries. Select the range of cells On the menu bar, click on format, conditional formatting Under Condition 1, select Formula is In the formula =Countif (column range you are […]

Continue Reading →

Excel Tip: Quickly Enter the Date and/or Time

Posted on 12. Apr, 2012 by in VirtualConnections Newsletter, Windows Resources/Tips

Want a way to quickly enter today’s date?  Press Control + ; (Ctrl and semicolon simultaneously). Now if you also need to enter the time just press Control + Shift + : (Ctrl, shift, colon simultaneously). Another way to get the most of those keyboard shortcuts.

Continue Reading →

Excel Tip: Force a Line Break In a Cell

Posted on 28. Mar, 2012 by in VirtualConnections Newsletter, Windows Resources/Tips

You are working in an Excel file and entering text in a column but you want to start a new line and hitting enter/return just brings you to another cell. To edit the cell, press F2, type your text and then press Alt-Enter to bring the cursor to the next line and continue typing. The […]

Continue Reading →

Excel Tip: Quickly Add Values in Cells

Posted on 13. Feb, 2012 by in VirtualConnections Newsletter, Windows Resources/Tips

You are working on a fairly large spreadsheet and you just want to know the total of a certain group of numbers, perhaps of one product available in different sizes or sales numbers for a particular customer. There is a quick way to get the value without having to key in a formula. Click once […]

Continue Reading →

MS Excel Tip: Transpose Rows and Columns

Posted on 10. Feb, 2010 by in Windows Resources/Tips

You just spent time setting up a new worksheet and realized that you want the columns to be rows and the rows to be columns. Well don’t fret, you do not need to start from scratch. Just highlight the table, click Copy, then go to another area of the worksheet and select Paste Special. On […]

Continue Reading →