Arthur Ramirez20 said:I'm typing up some text in Word, and now I want the whole thing to be centered vertically on the page.
Go to File -> Page Setup -> Layout, and then look for Vertical alignment: centered.
Home ›
Nicholas King › Posts
Posts by Nicholas King
1236 posts shown.
Go to File -> Page Setup -> Layout, and then look for Vertical alignment: centered.
Michael Jackson10 said:This is how you handle it in Excel—and I just tested it myself using some makeshift data—I managed to pull everything together (without any unnecessary fluff) in about 30 seconds...
A Pivot Table is frankly an "overpowered weapon" for a problem like this, though I suppose for a beginner, it might seem a bit... stubborn.
Smith's solution is actually what the person needs here—it provides a formula that they can actually grasp at any given moment, giving them total control over the situation. 🙂
rapidhawk23 said:Thanks, Sister, I actually managed to pull that off. But now—here's the catch—I need to take a final grade from two decimal places and turn it into a whole number so I can get a final score of 1, 2, 3, 4, or 5. Right now, I’m just using cell formatting to change how it looks. However, when I try to run some statistics—you know, like counting how many students passed with a 2, 3, 4, or 5, or how many failed (1)—it just isn't working. It seems like COUNTIF won't recognize cells that have just been formatted. What am I supposed to do here???
Don't just mess with the formatting; you should probably just use =ROUND(argument).
Ashley Collins36 said:Well, you all just completely cut me down at the starting line—honestly, now I’m actually a bit hesitant, maybe even a little embarrassed, to even bother attaching my "work" here. 😁
It seems like nobody actually bothered to cut anything—not even a single thing. I suppose you’re looking for me—or perhaps you’re just testing the waters to see if I’m actually paying attention here. If there’s something specific you need addressed, or if you have some grievance you’d like to air, go ahead. I’m listening, though I can’t promise I won't find your reasoning... lacking.If you take a moment to actually scroll through this thread, you’ll see that nobody ever gets shut down here—no matter how basic or elementary their question might seem. Back when I was first learning the ropes, there were always people willing to lend a hand, and I suppose that creates this sense of obligation—this feeling that you owe it to the next generation to pay that kindness forward. But, honestly, you’ll eventually come to agree with me... The method. I mean, if I’m being completely honest—and I suppose I should be—that performance you gave could have been significantly better. It wasn't exactly a disaster, but there was definitely room for improvement.
I honestly think that attaching raw, actual data is probably not the smartest move—unless, of course, someone can actually prove that there is absolutely no other way to get the job done. 🙂
I suppose I'll attempt to navigate my way through using those links you provided—hopefully, they actually lead somewhere useful. Much appreciated!
From what I can gather—and I might be wrong here—the link I shared seems to do exactly what you’re looking for. It features a pretty intuitive dialogue box for configuring all the settings, which makes things much easier. You should be able to select the specific Excel sheet you want to pull data from, determine the connection method, and handle all those other little details without much fuss.
Ashley Collins36 said:If anyone actually knows how to handle this and is willing to lend a hand, I would be incredibly grateful.
http://www.rondebruin.nl/merge.htm
Ashley Collins36 said:Aha. So, there are about 500-600 documents that need to be merged into one single file. Roughly 150 documents per month.
Do you actually have a suggestion, or are you just being nosy?
Look, 500 to 600 documents isn't exactly "a large volume." I certainly hope you aren't describing your symptoms to your doctor with that same level of "detail and precision."
Maybe save the passive-aggression and the sarcasm—especially in a situation where you're actually asking for help—for someone else. I’ve never been one to go looking for praise or a thank-you note, but I do think I have the right to expect at least a modicum of politeness from people who are supposedly seeking assistance.
Goodbye.
Ashley Collins36 said:I’m looking for some help if anyone happens to know the answer.
Is there a way to merge multiple Excel files into one single workbook—specifically, where the data from each subsequent file just gets appended directly underneath the previous one?
I think I explained that clearly enough, hopefully.
Is there some sort of massive, underlying reason why you wouldn't just use the standard copy and paste method? 😕
restlessheron19 said:I really wish that zero wouldn't show up... basically, I want the formula to leave the cell blank instead of displaying a zero.
Is there actually a way to pull that off?
=IF(Sheet1!A1="", "", Sheet1!A1)
If you’re looking for a workaround—and if you don't want to mess with formulas—you can actually just go into the settings in Excel 2007 and toggle off the display for all zeros in cells via the Advanced Options. If you do that, you probably won't even need that IF statement.
Joseph Chavez7 said:I hope I made myself clear enough..
Give this a shot:
=IF(A1>B1;MIN(4/3;B1+1)-MAX(1,125;A1);MAX(0;MIN(1/3;B1)-MAX(0,125;A1)))
In cell A1, you'll put the start time, and in B1, the end time (entered just like, say, 9:00 PM).
The formula doesn't quite hold up when you throw some extreme data at it—for instance, if someone works from 5:00 AM until 4:00 AM the next day.
Carl Castillo69 said:I’ll write a few sentences, toss in an image, try to set it behind the text, and—I don't know—everything just goes haywire! Some glitch keeps moving my text and images all over the damn page!!!!!! I just want everything to stay exactly where I put it manually, without it jumping around unless I actually move it myself, you know?
The thing is, in Word, an image gets "anchored" to a specific paragraph—it basically shares its fate—so if that paragraph shifts, the image moves right along with it. If you turn on the "Show/Hide ¶" tool (you know, the one that shows paragraph marks and other formatting symbols), select the image, and look near the end of a paragraph, you'll see a little anchor icon indicating where it's stuck.
If you’re looking to have a fixed image sitting in the background, honestly, you might be better off just inserting it into the Header.
And another thing—I'll make a document in Word and then use Adobe Acrobat to print it out as a PDF, but suddenly all my images turn some weird shade of blue.
Either you have the output set to grayscale, or maybe you should try using different software (like CutePDF, for instance).
Larry Ward8 said:basically just a small accounting program
Now we're talking. 🙂
You really have two paths here: you can look at what’s already available on the market and then figure out how to sync your data with a finished product—and honestly, just because your data is currently sitting in Excel doesn't mean everything *has* to stay in Excel—or, you can start from scratch and build something specifically to solve your exact headache.
The second option always sounds more appealing—because an "off-the-shelf" product can never be quite the perfect fit for your specific needs. But, there are a lot of "buts" involved in that logic. 🙂
Since you aren't exactly an expert in Excel / Access / whatever tool would be used to build this, you’d essentially have to find someone, explain your requirements, wait while they build it, then test it... Most importantly: during the development phase, you'll inevitably think of a million more ideas and a million tiny details—you can see for yourself how the initial simple explanation has already "grown," and I can already spot several potential future upgrades and automations: for instance, why manually printing? If there is so little work that you can just do it manually, then you don't even need a program in the first place; and so on; once it's "finished," you'll be completely dependent on that developer for every single tweak or upgrade. A custom-built product will certainly be much better and tailored exactly to your desires—but, it requires significant time and money. I'm not entirely sure if the "some money" you mentioned would actually be enough. 🙂
Disclaimer: I don't deal in these things (meaning, I'm not selling anything 🙂) — just a few things to chew on.
Larry Ward8 said:I want to have a list of companies in Excel—shortened names, like "John Doe"—and then, when I click a button, I want it to pull up the full details for that firm, you know, like "John Doe Corp," their Tax ID, and their business address.
Are you just looking to view this "expanded" data, or do you actually need to manipulate it somehow? Because, based on how you've described the workflow, I suspect you might be using the wrong tool for the job entirely—this sounds like a classic case where you really should be using Access.
Matthew Garcia4 said:When I type in 9.something, it keeps spitting out March 9th—what do I have to do to make it stop turning everything into dates?
The issue here is that the decimal separator isn't a period; it's a comma. When you use a period, Excel tries to interpret that data as a date, and if it can't quite make sense of it, it just defaults to treating the cell as plain text.
In older versions from back in the day, there was this annoying little quirk where Excel would stubbornly remember a cell's date formatting even after you cleared the content—so, in those cases, you'd have to go to Format -> Cell and manually set it back to "General."
Nathan Johnson4 said:It's me again... I was wondering if there's actually a way in Word to apply a Page Border to just one specific side? Every time I try to set it up, it applies to the entire document—or, if I try to remove it, it vanishes from everywhere. I even tried creating a separate document with just the single border I wanted and then copying it over here, but no luck; it just forces the border onto every single page again.
If you're using Word 2003, you can go into the Page Border settings, select "Custom," and then—using the little preview window—you can manually toggle the individual lines on or off depending on which sides you want to show or hide.
rapidgull27 said:I download a PowerPoint presentation in .pptx format.
Then I try to change it to .ppt—basically just stripping off the 'x'—but it still won't open? ????? Help me please!!!!
That’s not really how it works. 🙂
Go ahead and download then install the Microsoft Office Compatibility pack.
You aren't getting anywhere with this.
In Excel, cells don't come with borders by default—if you just hit print without doing anything, you won't see a single line on the page.
You have to actually select the specific range you want to outline and then apply the borders manually. On your screen, everything might look like it's all on one continuous sheet, but once it hits the paper, it’s going to look like three separate, disconnected tables (simply because the surrounding cells haven't been given any borders).
In Excel, cells don't come with borders by default—if you just hit print without doing anything, you won't see a single line on the page.
You have to actually select the specific range you want to outline and then apply the borders manually. On your screen, everything might look like it's all on one continuous sheet, but once it hits the paper, it’s going to look like three separate, disconnected tables (simply because the surrounding cells haven't been given any borders).
Of course it’s possible, but I think you really ought to be a lot more specific about how you actually envision this working. 🙂
Kyle Johnson2 said:you could also try using the formula =IF(B2=1;"/";"//")
The issue here—and I think he’s missing the point slightly—is that he actually wants to put that formula directly into cell B2, which... well, isn't exactly how things work in Excel. 🙂
restlessheron19 said:if cell B2 contains the number 1... I want it to display the symbol /
and if cell B3 contains the number 2... I want it to display the symbol //
I’m a bit lost here—which cells are you actually trying to put the "/" and "//" in? Based on how you've phrased this, it sounds like you want cell B2 to show "/" if it contains the number 1... but—and I mean this logically—how can a cell hold both the number 1 and a slash at the same time? 😕
ruggedmaker2 said:Printing PDFs, Excel files, or whatever else works perfectly fine—it’s just these specific Word docs that act up (not all of them, mind you).
I’d be willing to bet a few bucks that those documents have the page size set to Letter. Or, perhaps—though I doubt it—there's some strange configuration issue involving the paper source settings.