-
Hi, I create pivot tables for my work where I am plotting, on a per client basis (each line is a client): revenue, comission, etc. I organize by office. To make it easier for the offices to view the data, I use to show filter pages function to turn each offices list of clients into its own tab/worksheet...
-
Hello and thank you for reading this, my first ever forum post. I have been driven to seek help for an issue i know you will able to help me with. Scenario: I have produced a spreadsheet to record student scores for a number of tests. each test has three cells to it 1: the score (entered by the instructor...
-
Hi, I'm working in Excel 2003 (which this forum evidently no longer has a link to), and have created a template for users to input number data. I have defined the cells they can edit and password protected the rest of the form. I would like the users to be able to group and ungroup, but once I password...
-
I couldn't find reference to it anywhere else... Is it not possible to have a button on the comment textbox toolbar to format VBA code? I'm thinking of something like on DDoE (colour highlight, monospaced), but not necessarily in the frame.
-
Our shop is in transition from excel 2003 to 2007. When we copy long numeric values from Excel 2007 into 2003 the data displays fine at first but when we format the data to text it displays as scientific. How can I convert the data in 2003 to text and have it not display the scientific format?
-
Hi Everyone, I am an average Excel user using 2007. I am trying to type text in a text box such that I place text in the the 1st line, skip a few lines by hitting the <ENTER> key, then add my next line of text. The problem is when I hit the <ENTER> key, nothing happens. Also, if I hit the...
-
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...
-
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...
-
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...
-
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...