Posts by Kyle Johnson2

Amy Rivera66 said:I get it now. Thanks for all the effort helping me out.

So what now?
The rest of us should probably be thanking you for finally explaining how you figured it out and fixed it yourself. ???

Think you'll be back asking for help again soon?

Ugh, I just "love" people who ask for help but then won't lift a finger to share the solution with everyone else. 👎

hiddennomad13 said:My bad, didn't read everything super closely—just looked at your fix... Only issue is it’ll spit out a zero for empty cells, so you gotta add a check to see how many letters are actually in the column.

Pretty sure those formulas you posted aren't quite hitting the mark again. They're based on columns and they skip the first cell.
If the second cell is blank, it shifts everything else and misses the first one entirely. Try leaving every other or third cell blank across a few rows or columns to test it.

The goal is to get all cells reversed, whether they have data or they're just empty.
I put a file for you to download ON THIS LINK so give it a shot and let me know what you think.😉

hiddennomad13 said:=INDEX($A$1:$A$1000;COUNTA(A1:$A$1000))

@hiddennomad13/">@@hiddennomad13
was waiting for you to jump in with an explanation, but whatever.

That formula caught my eye—you were definitely on the right track. The way you wrote it, though, it’s locked to one column (A), so you can't just drag it right to get what you need. Still, solid idea.

@Jessica Lopez19/">@@Jessica Lopez19 has 50 columns and 70 rows and needs to flip the data in a single row. So instead of A:AA, she needs AA:A covering the whole range to get those results (if I'm reading this right).

Your formula actually works great for auto-filling if you tweak it like this:

=INDEX($A1:$AA1;COUNTA(A1:$AA1))

Or specifically for her setup since the data is on Sheet1:

=INDEX(Sheet1!$A1:$AA1;COUNTA(Sheet1!A1:$AA1))

Just a heads up—this only works if there aren't any empty cells in the range (they gotta be zeros).

Basically, this kind of formula can be dragged across rows or columns easily because the cell references are set up with absolute columns and relative rows.

hiddennomad13 said:It’s basically just writing formulas... Here's how you automate it...
=INDEX($A$1:$A$1000,COUNTA(A1:$A$1000))

"Automate it"? What does that even mean? How is that supposed to work for her massive 50-column by 70-row setup?

Jessica Lopez19 said:Look, let me lay this out clearly. What I need is for a single 50 x 70 table on one sheet to automatically generate on a second sheet. The data needs to stay in the exact same rows, but the actual cells should be populated in reverse order...

I don't see the issue here.
Just run an example based on what you're trying to do.

On Sheet2, set up the formulas (using relative references in reverse)

A1: =IF(Sheet1!AA1<>"";Sheet1!AA1;"")
B1: =IF(Sheet1!AW1<>"";Sheet1!AW1;"")
C1: =IF(Sheet1!AV1<>"";Sheet1!AV1;"")
D1: =IF(Sheet1!AU1<>"";Sheet1!AU1;"")
.....
Or if you want the flipped version
=IF(Sheet1!AA1="";"";Sheet1!AA1)

but unfortunately, it trips up at A1 B1—it won't keep going backward, it just keeps copying forward from A1 B1,

Excel doesn't work like that; it won't drag a formula backward.
For that first row on Sheet2, you’ve gotta do it manually—cell by cell, formula by formula. Go slow and be careful, because when you're doing the same repetitive thing over and over, that's usually when mistakes happen.
Once that's done, just select the first row and drag it down to row 70.

Another way is to go cell by cell using Copy => Paste Special => Paste Link from Sheet1 to Sheet2.
If you do that, everything on Sheet2 will update whenever you change Sheet1, but keep in mind: if a cell is empty on Sheet1, it’ll show up as a zero (0) on Sheet2.

Benjamin Wilson7 said:such nonsense.

Why call it nonsense? Maybe they just don't know yet (they gotta learn). Heck, maybe they opened Excel for the first time ten days ago. 😉

@Jessica Lopez19/">@@Jessica Lopez19
Do this:

Let's say you typed the word LETTER in the first row across columns.
A1=> L
B1=> E
C1=> T
D1=> T
E1=> E

Put these formulas in the next cells in that same row:
G1: =E1
H1: =D1
I1: =C1
J1: =B1
K1: =A1
Highlight "G1 through K1" and drag it down for as many rows as you need. Now every cell will have those same letters, just reversed.

If you want the whole thing reversed in one single cell, just put =CONCATENATE(E1,D1,C1,B1,A1) into cell G1 and copy it.

Just adding to my last post
Here’s that tutorial you wanted How to make self-adhesive labels in Microsoft Word 2007
Hope this helps you sort out the issue 😉

Olivia Palmer86 said:I AM DESPERATE, PLEASE HELP

Check out this step-by-step guide on making address labels in Microsoft Word 2003. Also, here’s how to do circular mailings in Microsoft Word 2003 and Microsoft Word 2007

Amy Turner said:Every single time I work on a doc and try to save it under a new name...

First off, clear out your TEMP folder—just wipe everything in there. It’d also be smart to turn off AutoSave and hunt down any files ending in *.tmp with a $ in front of the name (you'll need to have hidden files visible, like in Windows XP or Windows 7),

Second, grab a folder you call "experiment" and make a copy of that document there to mess around with. Try opening the glitchy file and deleting everything inside, then see if it saves. Other option? Open a totally blank one. Copy over paragraph by paragraph (skip the empty lines) from the old one to the new one. Save after every single paste. If the first 5 paragraphs are fine but it breaks after the 6th, then you know exactly where the error is hiding... etc.

BTW: If it isn't top secret, upload it somewhere online so we can take a look and see what's up. (Just scrub the sensitive parts)

If you're feeling like reading, check HERE for a bunch of tips on how to fix this mess.

Nicholas King said:I mean, I don't get why she had to go through all that trouble deleting the chapter numbers she typed in manually just to redo the whole thing using Outline Numbered styles... 🙂

Look, nobody’s forcing her. If she's gonna learn how to do this right, she might as well learn the proper workflow. Next time, she'll know she doesn't need to touch the numbering at all—just stick to the styles. But hey, everyone's got their own way of doing things. Not gonna lecture her on it. 🙂

Keith Wells2 said:I don't get 🤷
Can you walk me through it?

Does this actually help?

Just check that tutorial again.

Sarah Adams48 said:So, should I just highlight all the headings and subheadings, strip out the chapter numbers, and then generate a proper table of contents?

If I'm following you, you've already manually numbered all the chapters, headings, and subheadings.
1
1.1
1.2
2.
2.1
2.1.2

Just kill 'em.
Tag those specific headings and subheadings using styles like that tutorial showed you.
Once you do that, Microsoft Word will handle the numbering for you when you build the TOC.

Grace Miller said:So, instead of getting "under the same conditions in 1958," I end up with "under the same conditions in 1958 Year." How do I fix this?

Word Options => Proofing => AutoCorrect Options

Just uncheck: Capitalize first letter of sentences

Sarah Adams48 said:Even if I hit select all before messing with formatting, that right margin is still totally wonky.

Check this link out—it’s got a full tutorial with screenshots to help you out.
How to Create Table of Contents in Word 2007

Mark Fox8 said:Wondering if there's any way to get a file back on my PC

If you were working on it right there and had auto-save running, check out my thread over on this sub

http://www.forum.com/showthread.php?t=594952

Nicholas King said:No way—you've got two zeros right there in 100. 😁

Zeroes aren't here, but we've got ones. 😉

Daniel Robinson59 said:can someone just tell me the easiest way to wrap my head around this? Like, what formulas am I supposed to plug in, and how do I get the data into a table that basically builds itself? Any help would be huge, thanks.

check if these instructions and formulas do the trick for you

- Tracking Football Scores in Microsoft Excel>

Nancy Rodriguez38 said:I already did all that.

? 😕

Nancy Rodriguez38 said:The only thing I did was pick the "2 pages per sheet" option, and when it prints, it looks fine.

So what's the issue then?

Nancy Rodriguez38 said:What I'm wondering is if there's a way to get a line down the middle during printing, so you can actually see a "physical" gap between those two pages on the printed paper?

Yeah, you can. Just draw a line right down the center between the two columns. If you've got a ton of pages, just use the
Watermark option . -
Here's an image you can pull into the Watermark
tool. It'll look just like the picture (basically a divider line between the columns).

Nancy Rodriguez38 said:Can you please explain the difference between the "2 pages per sheet" and "Book fold" options?

Honestly, looking at how many posts you've made on this forum, I'm pretty surprised you're asking this. 😉
- "2 pages per sheet" -
- "Book fold"

Nancy Rodriguez38 said:What I’m actually trying to do is get that A4 look—you know, set to Landscape, but with two vertical pages side-by-side like an open book. I managed to pull that off with the settings I used, but is there a way to add a line right down the middle of the sheet? Just something that shows up when it prints so I can see the divide. Uuuf, I think I made this way more complicated than it needs to be, but hopefully you guys get what I'm after.

Man, you really overcomplicated that one.
You should've just started a new thread with a fresh title instead of digging up this old one from the archives. 🙂

If you're trying to lay out book text in Landscape mode, try using columns instead.Make two columns. Switch it to Landscape.
Check this out if you're trying to print a book. Got it, looking for 2003 here. Use that as a guide for Microsoft Word 2007. Obviously, you gotta consider what kind of printer you're running, too.

This is from Microsoft Word 2003.

coppergardener22 said:I’m doing all that stuff from home since I don't have a computer anywhere else—still on the hunt for a job.

That threw me off. Thought you already had a gig, turns out you're just looking for something new.😉

The first email comes from our own domain (it's a family business with its own website).