I have four different spreadsheets that I linked into four Powerpoint slides (four quadrants and four slides covering regions i.e. Global, The Americas, EMEA...

I have a worksheet that is protected but certain cells are not locked so users can edit them, but I cannot select these cells. I can navigate to them by...

I saw a previous post that refered me to Maybe something for you at John McGimpsey's site. http://www.mcgimpsey.com/excel/lookuppics.html and I am able to...

I received this spreadsheet from a friend of mine. The column headers are all numeric from 1 to whatever. It has got to be simple, but for the life of me, I...

can use LINEST for linear trendlines, LOGEST for Exp. trendlines, but Ican't see how to get values for Power series trendlines. Anybody help

Can anyone tell me how to create a formula that will take a column of invoices (just a numerical value like 108007) and display back the missing numbers...

I accidentaly right-clicked and deleted an excel file. Is there a way to recover this?

I have an Excel 2003 workbook with worksheet tabs named after the months of the year (Jan, Feb, Mar, Apr,...) for 2009 and 2008. Each worksheet contains...

I have figured out how to unhide multiple sheets in a workbook - Sub Unhide_All_Sheets() Dim WS As Worksheet For Each WS In...

As a software developer who integrates Microsoft Excel using .csv files, I'd like to see the ability to specify an environment option which would cause all...

I have large workbooks that I query data from one sheet to the next based upon defined criteria. When the workbooks are small using 10,000 to 15,000 rows,...

Hi Is there a way to insert a blank row after each date? Thanks 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul

My Excel 2007 is set to the same number of columns & rows as prior versions. How do I change that? Thanks for your time. Otto

If a value is appearing once in the lookup array, I want operation of a simple Vlookup, however, if an entry appears twice or more times how to have a...

Does the speed of execution of xlfiltercopy get impacted if the data is formatted or not formatted? I am using the following inside a...

Charts, logos, pictures, equations, wordart and objects change size and positions when viewing in print preview and printing. We have tried changing page...

I recently had my computer re-imaged (or profile reformatted?) and am now picking up the pieces, so to speak. I'd like reformat the default text used when...

Excel 2007 spreadsheet is using conditional formatting to change the background of cells dynamically. The print preview nor the printout shows the cells...

I have started using Excel 2007 and have a great number of Workbooks that have been created in earlier versions of Excel. Is it best to use 2007's convert...

I have a workbook that I add a new sheet to every day. How can I copy a formula to the new worksheet only, then fill down to the last row? Thank you