Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pete1001
  • Content: Threads
  • Order by date
  1. pete1001

    Chart formatting

    Hi I need to create a standard column chart with two series of data with vastly different orders of magnitude and therefore need 2 y axes. Eg: apples 3.2 976 bananas 1.5 457 cucumbers 2.3 789 If I use the recommended 'format: selected data series : 2nd axis' to create a 2nd Y...
  2. pete1001

    Rounding

    I don't think there's an answer to this but you guys never cease to amaze...... I have a sheet with lots of big numbers & formulas & want to change the display so all numbers are displayed to the nearest thousand (ie 1,234,567 becomes 1,235,000). But, I don't want to lose underlying data...
  3. pete1001

    Referring to worksheet names in excel

    Everyone knows that you can refer to the worksheet name in headers & footers by using the &[TAB] function, but.... is it possible to do this in a cell? I can't figure it out - can anyone help? Pete
  4. pete1001

    Find/replace in headers and footers

    I have a many-worksheet workbook and need to find/replace in the header and footers. Each header and footer is slightly different so usual multiple selection of sheets and editing won't work. Any ideas?

Part and Inventory Search

Back
Top