HI, i'm trying to get the data from multiple worksheets into one worksheet but in list form so it lists all of the lines on one sheet together. i don't want to sum by a category or anything, just
Hi! What I'd like to do, is for excel to automatically (without calling the menu to run the macro) apply the following to a certain worksheet: if a cell D1 = "PL" (it's a dropdown menu) --> I want to
Normally, Word does behave exactly that way. If you just press the hyphen key at a point that could be the end of a line, the next character will start a new line. If you DON'T want the line to break at the hyphen, press Ctrl+Shift+hyphen to insert a "nonbreaking hyphen"; then the entire hyphenated word ("present-day") will be forced to the next line. This is especially useful when a number is ...
I have two books on Excel pivot tables and have spent considerable time searching--I just don't see it. Interestingly, Excel 2010 appears to have done this all automatically and correctly without my having even asked for it--after putting the calculated field in the 'values' box, both row and column summaries automatically appeared.
