Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Print issues with Excel 2007

    Was just upgraded to Excel2007 from Excel 2003. When I try to print any file created in Excel 2003 that has a pic/text box/ chart or any other object in the workbook it prints out of alignment(pics on text, text box/pics in different locations. It looks fine on the screen but when you print or print...
    Posted to Excel 2007 (Forum) by Jerry on Mon, Jan 4 2010
  • Re: Can't set header margins

    Yes, that's what I do to. I adjust the column width and get reasonable alighment. Must be a bug in the program!! I also experience the problem that when I'm in page layout, I can't always select a singe cell. The program selects a group of cells or rows when I click a cell. It drives me crasy...
    Posted to Excel 2007 (Forum) by john on Tue, Oct 6 2009
  • Excel Explosion and alternate shading to every other line

    I used Excel Explosion and created several files from my dataset. I selected the option to add alternate shading to every other line on the output. I've asked users to highlight changes that they've made to the file before sending back to me. The shaded cells won't allow a new fill color...
    Posted to General (Forum) by Linda Berardo on Tue, Mar 31 2009
  • ??? is there a way (function?) to store a number gained by calucalations into another cell where it is stored as a number free of calculations

    I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
    Posted to General (Forum) by caladdin on Mon, Jul 28 2008
  • Re: How to disable auto format

    Ali You could import it as text (*.txt or no extension at all) and using the wizard mark the columns you wish to hold as there exact representation as text (it's the third step). Then to convert those to numbers with the correct number of decimals you could read each cell, find the period and then...
    Posted to General (Forum) by Nick Hodge on Thu, May 8 2008
  • custom number formats

    This is probably an easy one for all of you... I have been creating a custom number format on new excel files almost daily. I want to create the format and save it so that the format comes up every time I open excel and start a new spreadsheet, just like the built-in formats. How do I keep the format...
    Posted to General (Forum) by Chiara on Mon, Apr 28 2008
  • Auto Format option in excel

    Team I am having problem in Excel when it do the auto format. I have a text file which has the following data which are tab separated value Name Date Amount1 Portion XXX 12-5-2008 11.25 10/25 When i load this text file into excel.(By changing the extension from .txt to .xls) It convert 11.25 to 25-Nov...
    Posted to General (Forum) by subhakarthi on Fri, Apr 25 2008
  • Re: Format help

    Tony May not help as they will become text representations of the numbers so not used in any onward calculations but =TEXT(DEC2BIN(A1),"0000") Will do it
    Posted to Excel 2007 (Forum) by Nick Hodge on Thu, Apr 3 2008
  • I want to create a standard deviation bell graph

    Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
    Posted to General (Forum) by vanse@hotmail.co.uk on Sun, Mar 30 2008
  • Re: Excel 2008 for Mac - Pivot Table Field Layout

    Thanks for your reply Roger. I also have Excel 2007 running on Windows Vista. I was able to successfully follow your instructions in Excel 2007 (Windows). Unfortunately, I have not been able to duplicate / crack the code for Excel 2008 Mac with your advice. It could be that I am missing something obvious...
    Posted to General (Forum) by OlsenPeterE on Mon, Mar 17 2008
Page 1 of 2 (11 items) 1 2 Next >
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.