Assume you have a big table of data on a worksheet and you want to easily move through it without going beyond its boundaries. Here’s a way to do that: first you select the region of cells you want t… more →
windows vistazellis wrote 2 hours ago: This is just a short list of features people sometimes struggle to find in Excel 2007. Office Assis … more →
Adam Vero wrote 1 week ago: Another of Simon’s excellent posts about the Ribbon and other parts of the Fluent UI in Excel 2007 h … more →
Adam Vero wrote 2 weeks ago: I agree with Simon in his article about the usefulness of cell styles in Excel, where he says: Style … more →
mgconsulting wrote 3 weeks ago: Scroll through Ribbon Tabs in Office 2007 You can use the scroll wheel on your mouse to scroll from … more →
bennyaustin wrote 3 weeks ago: How to Clone an Excel PivotTable? Ever came across a situation where you have to compare PivotTable … more →
Kiran P wrote 3 weeks ago: If it was in a version of Excel before 2007, what would any one do to remove duplicate rows? Simple, … more →
mgconsulting wrote 3 weeks ago: The following only applies to Access 2007, Excel 2007, PowerPoint 2007, and Word 2007. Each time you … more →
erikabelmonte wrote 3 weeks ago: Unfortunately, only a few logistics professionals know this powerful tool, Solver, and that´s why I´ … more →
mgconsulting wrote 3 weeks ago: The CONVERT function in Excel 2007 converts a number from one measurement system to another. For exa … more →
bennyaustin wrote 1 month ago: Comparison of KPI Types in SharePoint Server 2007 SharePoint Server 2007 offers five different metho … more →
panitha wrote 1 month ago: The file formats keep on coming! Google Announces .xlsx and .docx support I still remember the fir … more →
primavisi wrote 1 month ago: Formula-formula perhitungan yang telah kita buat susah payah di Excel haruslah kita lindungi agar ti … more →
mhelp2u wrote 1 month ago: How to use the AND function How to use the AND function in Excel. For more Office 2007 help vid … more →
mhelp2u wrote 1 month ago: Welcome to Mhelp2U. Mhelp is designed to replace traditional text based help with video clips which … more →
peterburnhart wrote 1 month ago: That Excel 2007 proficiency exam that we took (we being less than a handful of people)…it was quite … more →
thermalspindle wrote 2 months ago: I’ve recently been helping some colleagues develop some reporting templates and they had a ver … more →
sudeepjames wrote 2 months ago: What does merge and center do? Exactly that – it merges all the cells you have selected … more →
redroomsalon wrote 3 months ago: I keep getting asked that question, and I really have no idea. Yesterday, I inputted in an excel spr … more →
amiraryani wrote 3 months ago: I faced an issue in multiple projects where a software application uses Microsoft Office libraries t … more →