Archives: 14th October 2010

Windows 7 – DVD drive not found

In some cases your DVD drive may not be found by Windows 7, even if it’s visible in the BIOS and using the standard driver. Try running REGEDIT, browse to HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlClass, then delete both UpperFilters and LowerFilters in the right-hand pane (UpperFilters.bak and LowerFilters.bak entries can be ignored). If this doesnot resolve the issue, resetting

Read More


Copy a formula in Excel

Select the cell that contains the formula  you want to copy. On the Home tab, in the Clipboard group, click Copy. Do one of the following: To paste the formula and any formatting, on the Home tab, in the Clipboard group, click Paste. To paste the formula only, on the Home tab, in the Clipboard

Read More


Excel Keyboard Shortcuts (2007)

Useful Keyboard Shortcuts Format any selected object, press ctrl+1 Insert current date, press ctrl+; Insert current time, press ctrl+shift+; Repeat last action, press F4 Edit a cell comment, press shift + F2 Autosum selected cells, press alt + = Recalculate formulas, press F9 Select data in current region, press ctrl+shift+8 See formulas in the worksheet,

Read More


HIDE THE RIBBON IN EXCEL 2007

In Excel 2007 the Ribbon which replaces the menus and toolbars found in earlier versions of Excel, can quickly be hidden to give you more room to work on your spreadsheet. To Hide the Ribbon: Double click on one of the ribbon tabs – such as Home, Insert, or Page Layout


Keep your data safe Access

Back up your database before you edit or delete records to help protect the database from system failures and also against mistakes that the Undo command cannot fix.   It is also a good practice to make a backup of your database before you run any action query, especially if the query will change or

Read More