Home › Walter Jackson48 › Posts

Posts by Walter Jackson48

234 posts shown.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Nov 4, 2011

Raymond Collins18 said:I need some help here! How can I set up a command in a single data range so it always sums the last ten cells? If we have a defined field from A1 to A50, how do I make A51 always show the result of the last ten entered values?

Try putting this formula in A51:

=SUM(OFFSET(A1;MATCH(E1+306;A1:A50;1)-1;0);OFFSET(A1;MATCH(E1+306;A1:A50;1)-2;0);OFFSET(A1;MATCH(E1+306;A1:A50;1)-3;0);OFFSET(A1;MATCH(E1+306;A1:A50;1)-4;0)). This formula should sum the last four cells in column A, and you'll see the logic... you just keep going down to -10.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Nov 3, 2011

Henry Lewis37 said:Look, I just can't wrap my head around what you're saying,

Try typing this formula into G27: =IF(F27>B27;F27&" NE";""). That should force G27 to display the actual budget figure—provided it's higher than what was planned—and tack on an " own" right next to it in the same cell. For instance, if your planned budget in B27 is 300, but the actual amount in F27 hits 350, then G27 will show "350 NE". Also, if you set up conditional formatting for the cells in column F (starting with F27, F28, F29, etc.) using the method I mentioned before, that number 350 in F27 should pop up in bright red.
I think we've handed you enough pieces here to finally piece together a solution.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Nov 2, 2011

Henry Lewis37 said:I don't really know how to pull this off, but I'm in a massive rush and could really use some help if anyone can step up.
Thanks in advance. 🙂

First thing: just type the formula =SUM(C1:C14) into cell D16.
Second part: Select your F27 cell, then head over to the Formatting tab and click on Conditional Formatting. In the conditional formatting menu, pick "Use a formula to determine which cells to format," and in the empty field next to it, type in =F27>B27. While you're still in that same menu, go to Format, set the font to bold, maybe pick a red color, and hit OK. Once that's done, just copy cell F27 and paste it down into F28 and F29.

Once your budget actually exceeds what was planned, the number in that cell will turn the color you picked—in this case, 3500 would show up in red.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Oct 27, 2011

Anthony Barrett11 said:Hey there...

Look, it’s pretty straightforward if you just slow down and look at it. Take Sheet1, for instance. If you type a formula like =SUM(M41;M42) into cell C1, you’re basically telling Excel to add up whatever is sitting in cells M41 and M42. Simple enough, right? Once that's done, you can head over to Sheet2. In cell B1, you could just type =Sheet1!C1. Or—and this is what I usually do because I don't have all day—you just go to Sheet2, hit the equals sign in cell B1, then physically click over to Sheet1 and click on cell C1. It works every time.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Oct 25, 2011

Amy Rivera66 said:I think I need some help with rotating things in Word.

Go back and check out my post from August 22, 2011. It might actually be useful for once.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Oct 15, 2011

Raymond Collins18 said:Hey everyone!
Can anyone give me a hand with this?

If I’m following your logic correctly—and I try my best, though sometimes these things get muddled—you might want to try something like this: let's say you're plugging numbers like 3, 4, or 5 into cell G1. In that case, just pop this formula into H1, then drag it down to H2 and H3: =IF(G1=3;A1;IF(G1=4;B1;IF(G1=5;C1;""))). It’s a bit tedious, I know. If you have more numbers coming in through column D and so on, you’ll just have to keep nesting them—asking if G1 equals 6, and so forth. And look, if those columns A, B, and C are packed with ten rows of data, you're going to need to copy that formula all the way down to H10. Just a thought.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Oct 6, 2011

Samuel Price58 said:I'm just trying to get some study time in before my college classes start, working through this one problem in Microsoft Excel 2007[/url]

Look, I'm pretty sure what’s happening here is a mismatch in your system settings. Your Regional Settings probably have the number format set to something like 12,000.00, but for this specific task to actually function, you need it formatted as 12.000,00. It’s one of those annoying little technicalities that drives me up the wall. Just hit the Start menu, head over to the Control Panel, find your Regional Settings, and switch the number format to 12.00,00. That should sort it out.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Sep 27, 2011

I’ve tried doing it that way, but honestly, it just isn't working for me...
Please, if anyone has any bright ideas, I'm all ears.

Give this a shot:
Go through the menus one by one: Tools, then Options, then Edit. If you see "Top and bottom" selected under the Insert/paste pictures setting, that might be exactly why everything is falling apart on you. Try switching it to "In line with text," or maybe pick any of the other options besides "Top and bottom." Then, in the Picture editor field above, select Microsoft Word. The fix is actually pretty simple, but it's definitely worth a go... (I'm running the 2003 version myself).

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Sep 22, 2011

Kyle Johnson2;@Walter Jackson48 said:

"together we're stronger"

And likewise, sending my best.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Sep 22, 2011

cosmicbison19 said:Hey there,

I've got a quick question here....

Thanks

Try dropping this formula into column B; it actually works even if you have a zero sitting in A1: =IF(A1:A10=1;COUNTIF(A$1:A1;A1);"")

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Aug 22, 2011

Larry Booth said:Hey guys...

.

Look, it just doesn't work that way. If I'm following this whole mess correctly—and I think I am—you can't have both the raw formula and the calculated result sitting right there in the same cell at once. That’s just not how software works. If you click on a cell showing a result, you'll see the actual formula sitting up there in the formula bar at the top of the sheet. For instance, in F19, as we already established, the formula is =200/G19. It's basic logic.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Aug 22, 2011

darkrider7 said:Can someone please explain how to rotate a table in Word 2007? I’m seriously losing my mind here... I am about two seconds away from smashing my computer to pieces. Help meeeee🙏 🙏 🙏 🙏

Back when I was stuck using Word 2003, I had to resort to this ridiculous workaround: I'd open up a blank page in Word and set the orientation to landscape. Then, I’d draw a frame using Drawing. I would go over to the document containing the actual table, copy it, and then drop it inside that frame I just made. You have to be careful not to let the table get too close to the edges of the frame, otherwise, it'll cut off your last column—it drives me crazy. Once that's done, I'd right-click the frame and change the border color to white so it stays invisible later on. Then, in the actual document where I wanted the table to live, I’d insert a clean page, fix up the header, and go to Paste Special. I'd pick Picture (GIF) or whatever format looks similar enough, and hit OK. Once the table is pasted in as an image, I just click it so the frame shows up, then rotate the whole "picture" 90 degrees to the left. After that, I just fiddle with the image until it looks right. If I need to move it around the page, I click it, switch to the selection tool (Highlight), and then I can drag it wherever I want. That’s it. It's a bit of a hybrid mess, but it worked for me. Hopefully, that helps you out with your 2007 version.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Aug 12, 2011

William Gonzalez44 said:I've got a bit of an issue here

Look, from what I can see, you’re splitting the row instead of the column. That's a mess.
Try this instead: Copy your table over in Excel, then go into Word, hit EDIT, choose Paste Special, check the box for Microsoft Excel ....Object, and hit OK. If you actually want to move that table around once it's there, just left-click it to select it, right-click, hit Format Object, go to Layout, and set it to Tight. You'll see a little crosshair icon appear, and then you can drag it wherever you damn well please. Works perfectly fine on my version of Word 2003.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Aug 9, 2011

crimsonraven6 said:he's just lining up the names next to those numbers

Let’s give this another shot, shall we?
Look, if you've got names sitting in Column A and then their corresponding totals or sums over in Column D, you can't just pick one and hope for the best—that's how you end up with a complete mess. You have to sort both columns in unison. What you need to do is select the entire table first—don't skip that part, seriously—then go into the Sort menu. Set your primary sort to Column D, and then under the "Then by" option, select Column A. It’s not rocket science, but if you don't grab the whole range, everything falls apart.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Aug 9, 2011

crimsonraven6 said:No, it just won't work, man.

Look, if I have numbers in columns A and B and their total is sitting right there in Column C—it works for me. (And honestly, excuse my previous mess-up; instead of saying "adding" or "to add," I really meant "sorting" and "to sort." My brain was elsewhere. Anyway, let’s try this again, schoolbook style:) Select Column C (the sum), then go to Data, then Sort, make sure you check the box next to Expand..., hit Sort ; Options, ensure the First key sort order is set to Normal, check the box for Sort to bottom, click OK, and then in the Sort by field, select Column C and hit OK. That should do the trick.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Aug 8, 2011

crimsonraven6 said:just a quick little question regarding Excel

It’s basically the same old routine, just switch over to summing up the column. Go into Data, then Sort, hit Sort again, click on Options, and make sure you check that "Sort top to bottom" box. Then you just tell the program which specific column you want to sum up.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Jul 23, 2011

Elizabeth Fowler46 said:Is there any way to just wipe out every single image in a Microsoft Word document all at once? How do I actually do that? 😁

Look, I’ve dropped a few links here for you—it's a whole collection of tools, so go ahead and dig through them until you find something that actually works for your specific headache.

http://www.sobolsoft.com/worddeletepicture/

http://www.sobolsoft.com/

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Jul 21, 2011

Elizabeth Fowler46 said:Is there any way to just wipe out every single image in a Microsoft Word document all at once? How do I do it? 😁

Well, if you want to play it by ear, you could try holding down the Ctrl key while you click through them to select everything, then just hit Delete. It’s a bit tedious, honestly—I remember spending an hour doing something similar back when I was working on a massive report for my old firm in Chicago—but if you hold Ctrl while clicking each one, you can eventually just delete the whole lot. That’s it, assuming we're on the same page.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Jul 18, 2011

Joseph Thompson10 said:Hey there...
Can anyone please tell me how to pull this off without having to manually scroll through all 18,000 rows? It’ll take me an entire week if I try to do it by hand. 😢((

Try this instead: Go to the Data tab, hit Filter, then select Advanced Filter. In the List range box, just highlight the data you're working with, check the box for Unique Records only, and hit OK.

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...) in Software · Jul 8, 2011

Rebecca Wright63 said:tonight
Can someone please help me out? So, I'm working in Word and whenever I type quotation marks, it keeps giving me "word" like this, but what I actually need is for them to look like
,,word"
How on earth do I fix that setting?
thanks

Look, if you can't find the setting in the menu, just do it manually: use Alt+0132 for the opening quotes and Alt+0147 for the closing ones (this works in Microsoft Office 2003)