[Excel 2007 filter] Is it possible to input some text into a cell, e.g. "Click here for Worksheet 2" or similar, and create a hyperlink on that cell to open, uh, Worksheet 2? In the same window, not a new instance. Neither a search of AskMe and/or the Excel help-screens has been successful. Thanks in advance.
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
Excel 2007 issue: I'm trying to have Excel mark matching data in two columns with some kind of color or formatting. [more inside]
How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows? [more inside]
Windowing problem in Excel. [more inside]
I suspect I have a problem using OS X to upload a CSV file to a webform, and I suspect I’ll need an XLS guru to help me figure it out. [more inside]
My parents just bought a MacBook to replace their ailing old PC laptops. They do their business management in Excel 2003 on those machines, but want to switch to 2008. This process is apparently an exercise in frustration. [more inside]
Excel 2003 - how can I get 2 or more xls files to open in separate windows? [more inside]
What's wrong with my copy of Excel 2007? [more inside]
Dealing with a big Excel database. [more inside]
Is there some way to link an Excel spreadsheet and Word document such that a portion of the Word document will update automatically from changes in the Excel file? [more inside]
How do I format cells in EXCEL to accept numeric values in the form: -26:32 (or +26:32 ... that is, mm.ss but including the pos/neg sign)? I'm trying to compile a simply list of Messier Objects (astronomy) and can't figure out how to include declinations.