Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

So, I've run into this annoying little headache. Check out this link here:

I'm trying to figure out how to shove all the text into the left Column. The thing is, if there isn't enough content to fill things up, it just automatically centers everything or splits it across both Columns :S

Douglas Miller60 said:how do I get all this text into just the left Column

If I’m following you correctly—and I usually am, despite how much people ramble—you’ve got a page set up with two columns, but you want everything shoved into the left one. If the Column tool is being stubborn and won't cooperate, and since you don't have a massive amount of content here, I've got a bit of a workaround for you. It's a little messy, but it works if you're desperate:
Use the Column tool to turn the whole thing back into a single column first. Then, just Cut the text. Once that's done, create a Text Box on the same page and position it specifically over the left half of the sheet. Paste your cut text right in there. Highlight the whole block and hit Ctrl+J to justify it so the edges look clean on both sides. Finally, just "paint" the Text Box fill white so it blends in and looks like part of the page.

I'll give it a shot, thanks a ton 🙂

Douglas Miller60 said:how do I get all the text into the left Column? if there isn't any more text, just move it over so it fills both Columns :S

Looks like you've got some dead space hanging out behind that left paragraph.
1. Just pop your cursor at the end of the left paragraph and mash the DEL key until everything pulls back into the left Column.

2. If that’s being stubborn and you don't need to email the file digitally, just drop a table cell or a Text Box right under that left paragraph. Set the borders to invisible and just shove your text inside that box.

Hey guys, does anyone have a link or maybe a torrent for an old version of Office 2007? Ideally a bundle that includes 2003 too... I just can't deal with this annoying pop-up window in the attachment anymore. It pops up every single time I open a file and honestly, the constant waiting is driving me nuts...

THANKS EVERYONE!!

Image: http://oi41.tinypic.com/2hmmt7l.jpg (couldn't figure out how to upload it directly)

Here’s a guide on how to actually run multiple Microsoft Office suites at once—it looks like your installation went a bit sideways. Just follow the steps laid out in this doc: http://support.microsoft.com/kb/928091

And seriously, stop hunting for links to pirated software unless you want a ban—it's not worth it. It would be nice if you actually took a second to read the forum rules before jumping in here.

Alright, I need some quick help with Google Slides—urgent. A friend of mine needs to animate every single word individually, like, each word flies onto the slide one by one... anyone know how to pull that off? Need an answer ASAP if possible! thanks in advance.

northernraven5 said:need help ASAP with PowerPoint 2010.

This tutorial wasn't made in PowerPoint 2010, but should still get the job done.

- Animating text in PowerPoint

I need some help troubleshooting an Excel formula,
here’s the setup: the first column represents a quantity, which is then being added up in the second column via a running total (cell + cell)

unit
quantity total condition
0.30 9.64 0
0.26 9.91 0
0.16 10.06 0
3.47 13.53 0
0.23 13.76 0
5.55 19.31 1st row
0.06 19.37 0
0.22 19.59 0

What I’m trying to achieve in that third column (the condition)
is for the formula to trigger once the cumulative sum in column two hits a specific threshold—in this case, 17.
Once it hits that mark, it should flag the condition and then reset its logic to continue searching through subsequent rows, but it needs to account for the overflow from the previous calculation. For example, since 19.31 minus 13.76 equals 5.55, the next cycle should start counting from that 5.55 increment until it reaches the next 17.

I know I've made this sound unnecessarily complicated, but hopefully someone can make sense of what I'm after.

Thanks in advance,

P.

I think I have a pretty simple question here:

I've got this Excel sheet with four columns

Mark 200 Pero 300
Pero 900 George 100
Chicago 300 New York City 400
Los Angeles 500
George 500
New York City 50

What's the best way to combine the names from both columns? 😁
Basically, I'm looking to get this

Mark 200
Pero 900 Pero 300
Chicago 300
Los Angeles 500
George 500 George 100
New York City 50 New York City 400

Thanks!

Joseph Fisher2 said:I have what should be a pretty straightforward question here:

I've got this Excel spreadsheet with four columns.

Mark 200 Pero 300
Pero 900 George 100
Chicago 300 Los Angeles 400
Marija 500
George 500
Los Angeles 50

How on earth do I merge the names from one column with the values from another? 😁
Basically, I need it to look like this:

Mark 200
Pero 900 Pero 300
Chicago 300
Marija 500
George 500 George 100
Los Angeles 50 Los Angeles 400

Thanks!

Look, if you have "Mark" sitting in cell A1 and "200" in cell A2, then you just do this:
The formula:

See, that ampersand symbol (&) is your concatenation tool. You could technically just write =A1&A2
but unless you want everything smashed together like "Mark200", you need that space in quotes to keep it readable.

If you're trying to pull data from four different cells, the logic stays exactly the same:
The formula:


RESTECP 😉

I think you misunderstood my point— 😁
names and numbers can stay in their own cells, but what I really need is for the names from the second column to be paired up with the amounts in the first one... basically grouping them all together.

Joseph Fisher2 said:gotta ask a simple (hopefully) question

Nah, actually isn't that simple at all
If you aren't satisfied with what JohnC put down, we gotta dig deeper.

Looks like the table is missing pieces and doesn't show the full picture, so there might be follow-up issues here.
1. Is everything in that first column unique (no repeats)?
2. Does the result strictly have to be "Pero 900 Pero 300" or can it just be "Pero 900 300"?

Basically, we need to know if those first column values are all unique. If they are, this should work:

Option one:
Say your data is in range A1:D6 and results go in G1:I6. First, grab those UNIQUE data points. Column G gets the unique stuff from column A, and column H pulls from column B.
Drop this formula into cell I1 and drag it down.
Code:

Then, pop this into cell L1
Code:

The results should look like this:
Code:

If that doesn't cut it, then we try option two.

Again, grab the unique info from columns one and two and put them in G and H.
Put this in cell I1 and drag it down.
Code:

Now, put this in cell J1 and drag it down.
Code:

Finally, one more for cell L1:
Code:

Result should be:
Code:

Joseph Fisher2 said:you didn't quite catch my drift... 😁
The names and numbers can stay put in their respective cells, but what I actually need is to take the people from the second column—like those guys from Los Angeles—and pair them up with the corresponding amounts from the first column. Everything needs to be grouped together properly.

Ah, my bad.
Look, I whipped up a quick macro for you; hopefully, this hits the mark.
Just a heads-up, if the program asks you when you open it, you’ll need to enable macros.

http://we.tl/UlpbQHSokZ

Just copy and paste all your data into this document and then hit the "Names" button.

My access to that macro station is blocked, but that first code from Kyle Johnson2 works like a charm—it was exactly what I needed, thanks!

Greetings, everyone.

I am currently working with an Excel file where the column widths are locked down. For instance, I cannot even double-click the boundary between columns A and B to auto-fit the cell to my preferred size.

I would appreciate some guidance here. This has become quite urgent, and I simply don't have the luxury of time to manually resize everything one by one.

Much appreciated.

Does anyone have any thoughts on this? It’s quite important to me.

Henry Lewis37 said:like, you can't even double-click between A and B to get the cell size I want.

There’s a few reasons for that. You should've uploaded the file for download so we can actually see what's going on—right now it's just guesswork. Just wipe the sensitive info but keep the data length the same in those problematic columns/cells.

btw: might be some merged cells or weird formatting issues. Try switching everything back to General.

Scorpion7, how is business treating you these days?

Kyle Johnson2 said:There are several factors at play here. You really ought to upload the file for us to review so we can see the actual issue; right now, we are just guessing. I suggest scrubbing any sensitive data first, then simulating the data length and structure within those problematic columns or cells.

On a side note: you might be dealing with merged cells or some specific cell formatting. Try switching everything over to General formatting.

File link:

http://en.file-upload.net/download-8...xcel.xlsx.html