Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...)

Sophia Newman6 · 2009-10-13T20:10:30+00:00

Can someone please help me out here? I need to number pages in Word, but I want the numbering to actually start on the third page. Does anyone know how to pull…

Nicholas King Regular

716 messages
joined Jan 2023

#381 · Mar 17, 2011

Walter Vaughn4 said:How am I supposed to sleep at night? Do I have to go into the settings? Like, where am I even supposed to find all this info so I can check it on one computer and then manually type it all into the other one?

Well, if I recall correctly—and I might be slightly off since I don't have my Outlook open right now—you should probably look under Tools -> Email Accounts (or maybe User Accounts, depending on the version). From there, you just pull up the properties, and you can jot down all those server configuration details.

Walter Vaughn4 Newcomer

7 messages
joined Dec 2010

#382 · Mar 17, 2011

Nicholas King said:I suppose you can find it under Tools -> Email Accounts (or User Accounts, I don't have Outlook handy right now). From there, just go into properties and jot down everything related to the server settings.

I'll give that a shot once I get home. Thanks for the help.

Kyle Johnson2 Newcomer

1 message
joined Feb 2015

#383 · Mar 17, 2011

Alexander Thompson83 said:I'm working on a survey for my senior thesis and I want to add those little radio buttons, but I have no clue how. Where are they hidden? How do you even get them into Word??

You didn't say which version of Word you're using?

A radio button is just an ActiveX control in Word (an Option button). You'll find it on the Control Toolbox toolbar. Check these links out, might help you out

- Radio buttons in Word 2003
- If you're using Word 2007 check this out
- If it's Word 2010, you gotta create a Forms toolbar first. For that look here

Michelle Jackson3 Newcomer

4 messages
joined Jan 2009

#384 · Mar 17, 2011

Greetings, everyone.

Can anyone walk me through creating a macro in Word 2007 that swaps out those pesky American accent marks (like é or ñ) for their standard English counterparts (like e or n)?

Nicholas King Regular

716 messages
joined Jan 2023

#385 · Mar 17, 2011

Noah Cooper40 said:Hey everyone!

Can anyone tell me how to write a macro in Word 2007 that swaps out American accented characters (like those special marks used in other languages) for standard English ones (changing things like č, ž, š into c, z, s)?

Here is one for č, now go ahead and run it five times. I actually recorded this back in the 2003 version—I'm fairly certain it should still work fine in your setup.

I suppose you could strip away some of these parameters within the "With" block, but if you do that, you're essentially gambling on whatever settings were left over from your last find-and-replace operation—and honestly, I’d rather have too much precision than deal with the headache of unpredictable results. 🙂

Sub czs()
Selection.HomeKey Unit := wdStory
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "č"
.Replacement.Text = "c"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False end Sub

cosmicbison19 Member

26 messages
joined Mar 2011

#386 · Mar 18, 2011

I was wondering if anyone might be able to help me out with an Excel formula...
Suppose we're looking at three specific cells.
The first cell will always contain a number, the second one could be either a number or some text, and then the third one is just another number.
So, I suppose what I'm trying to achieve is this...
I want to add the first cell to the second one, but if there happens to be text sitting in that second cell instead, then the formula should add the first cell to the third one instead.
It might make things a bit simpler, I guess, if the text used in that second cell is always the exact same thing.

If anyone happens to know how to pull this off, I think it would be an immense help.

thanks

Nicholas King Regular

716 messages
joined Jan 2023

#387 · Mar 18, 2011

cosmicbison19 said:Does anyone happen to know a formula for Google Sheets that does the following....

So, let's assume A1, B1, and C1 are your three target cells.

In whichever cell you want the result to show up, just plug this in:

=IF(ISTEXT(B1);A1+C1;A1+B1)

cosmicbison19 Member

26 messages
joined Mar 2011

#388 · Mar 18, 2011

Nicholas King said:So, let's say A1, B1, and C1 are your three cells.

In whichever cell you want the final number to show up, you could just pop this in:

=IF(ISTEXT(B1),A1+C1,A1+B1)

It works. Thanks!

Drew Bennett68 Regular

471 messages
joined Dec 2009

#389 · Mar 19, 2011

Kyle Johnson2 said:Just merge all the documents into one single file and create a new section for each one.

- Working with sections in Microsoft Office

That is exactly what I ended up doing! It involved quite a bit of fiddling around with the margins for each individual section, but honestly, it worked out. Anyway, a huge thank you to everyone who weighed in with suggestions!👍

Michelle Jackson3 Newcomer

4 messages
joined Jan 2009

#390 · Mar 19, 2011

Nicholas King said:Here is a little something for your hell; now go ahead and repeat it five times. This was recorded back in 2003, so I assume it still functions.

You could probably ditch some of those "With" options, but then you're at the mercy of whatever parameters you used during your last replace command. It’s better to have too many tools than none at all. 🙂

Hey, thanks, but I really need to record this as a macro rather than manually typing out the code. I've been scouring the web, but I just can't figure out how to convert those palatales into tags without the checkmarks. 🤷

Nicholas King Regular

716 messages
joined Jan 2023

#391 · Mar 20, 2011

Noah Cooper40 said:well thanks, but I really should be doing this by recording a macro rather than actually writing out code...

I'm sorry, but why is that? 😕

When you "record a macro," that is exactly what happens—the software "writes the code" for you. In fact, this was created specifically by using the macro recorder. 🙂

Kyle Johnson2 Newcomer

1 message
joined Feb 2015

#392 · Mar 20, 2011

Noah Cooper40 said:I should probably just record a Macro to handle this.

@LordByron already gave you the fix and the breakdown. If you really want to record a Macro "by yourself," just check out how it’s done—it’s the exact same deal in Microsoft Word.

- Wanna know how to record a Macro step-by-step? Here's the deal.
- Saving a Macro.

Anyway, here’s the full Macro code for all the palatals. Obviously, you can just strip out whatever parts you don't need, like @LordByron already pointed out.

Code:

Sub Macro1()
'
' Macro1 Macro
'
'
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "C"
.Replacement.Text = "C"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False end with Selection
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = "C"
.Replacement.Text = "C"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False end with Selection
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = "Z"
.Replacement.Text = "Z"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False end with Selection
End With
Selection.Find.Execute Replace:=wdReplaceAll
ActiveWindow.ActivePane.VerticalPercentScrolled = 0 Selection
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "DJ"
.Replacement.Text = "DJ"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False end with Selection
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = "S"
.Replacement.Text = "S"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False end with Selection
End With
Selection.Find.Execute Replace:=wdReplaceAll
ActiveWindow.ActivePane.VerticalPercentScrolled = 0 Selection
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "S"
.Replacement.Text = "S"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False end with Selection
End With
End Sub

Sarah Brown86 Member

10 messages
joined Mar 2011

#393 · Mar 20, 2011

Kyle Johnson2 said:@LordByron already provided the solution along with a full explanation. If you really want to record a Macro "by yourself," then take a look at how that's done—the process is identical for Microsoft Word as well.

- So, you want to record a Macro step by step? It’s actually quite straightforward once you get the hang of it, though people tend to overcomplicate the process. If you're looking to automate those repetitive tasks in Microsoft Office—specifically within Excel—you just need to follow a specific sequence. You aren't exactly "filming" a video of your screen; rather, you are telling the software to watch your every move and write down the code for you. First, you need to make sure the Developer tab is visible in your ribbon. If it isn't there, you'll have to go into your options and enable it. Once that's set, you simply hit the "Record Macro" button. From that moment on, the software acts like a silent observer. Every click, every cell change, and every formula you enter is being logged. A little tip from my experience: try to be very deliberate with your movements. If you're clicking around aimlessly or making mistakes, the Macro will dutifully record those errors too, and then you'll be stuck trying to fix a broken script later. It's much better to perform the task perfectly the first time. When you're finished, you just stop the recording. The steps are stored, and you can run them whenever you need to replicate that exact same workflow. It saves an incredible amount of time if you do it right. Simple enough, really.
- Recording a macro.

By the way, here is the complete Macro code for all the palatales. Of course, you can strip out certain sections if needed, just like @LordByron suggested earlier.

Code:
Sub Macro1()

'
' Macro1 Macro
'
'
ClearFormatting Selection
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "C"
.Replacement.Text = "C"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Execute Replace
With Selection.Find
.Text = "C"
.Replacement.Text = "C"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Execute Replace
With Selection.Find
.Text = "Z"
.Replacement.Text = "Z"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Execute Replace
ActiveWindow.ActivePane.VerticalPercentScrolled = 0 Selection
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "D"
.Replacement.Text = "DJ"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Execute Replace
With Selection.Find
.Text = "S"
.Replacement.Text = "S"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Execute Replace
ActiveWindow.ActivePane.VerticalPercentScrolled = 0 Selection
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "S"
.Replacement.Text = "S"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
End Sub

So, I’m assuming I just paste this code directly into Visual Basic, right?

Benjamin Wilson7 Member

15 messages
joined Oct 2008

#394 · Mar 20, 2011

Yeah. You want to know how to actually run it? And are you worried about case sensitivity? Because it keeps forcing everything into uppercase on my end.
So, if you just tweak the code to use lowercase "czs," it should work perfectly fine.

Keith Grant6 Newcomer

1 message
joined Mar 2011

#395 · Mar 20, 2011

Anyone got a link to download Microsoft Word online? Honestly, I don't even care which version...☕ ....thanks in advance!!!🙂

Jack Alvarez Active Member

69 messages
joined Jan 2014

#396 · Mar 20, 2011

Click

Kyle Johnson2 Newcomer

1 message
joined Feb 2015

#397 · Mar 20, 2011

Benjamin Wilson7 said:Wanna know how to run it and if capitalization is gonna be an issue? Because it keeps forcing uppercase, at least for me.
Basically, just use lowercase in the code and you'll be fine.

Lord Byron provided the macro order with lowercase letters, I used uppercase "on purpose." We gotta actually think a little here instead of acting like robots ;-)

@beyonce111

@fooreest basically answered your question. Those links—and even those tutorials more broadly—have plenty of info where you can wrap your head around how to record a macro order and how to run it.

If you want to record the macro order yourself (though I don't get why you'd ask how to record one when you already have the code and are asking where to put it?)
From what I gather, you want to learn how to record a macro, right? Pro tip: work on a copy of your document just in case.

Recording (creating a custom macro order by following specific steps in a task).
1. Hit the record macro button
2. Just go through all the steps you want, step-by-step—in your case, finding/replacing all the palatals
3. Stop recording the macro order
4. Add some text to that same doc (something containing those special characters)
5. Hit Alt+F8
6. Run the recorded macro
If it swaps out all the palatals, then you nailed it ;-)

Copy/Pasting existing macro code
1. Open the doc where you need to swap the palatals
2. Hit Alt+F11 to open the VBE
3. Double-click ThisDocument in the left menu
4. Paste the copied macro code into the right pane (there are pictures for this in that tutorial)
5. Head back to the doc and hit Alt+F8, etc., etc.

Nicholas King Regular

716 messages
joined Jan 2023

#398 · Mar 20, 2011

Kyle Johnson2 said:Nicholas King provided the Macro code using lowercase, so I "purposely" used uppercase instead. I mean, we really ought to be using our brains a little bit here rather than just operating like mindless robots ;-)

If my memory serves me right—and I could be wrong—if you type a lowercase letter in the "replace with" field and ensure "Match Case" is unchecked, then that replacement covers both cases. Essentially, you wouldn't need separate replacement steps for a lowercase or uppercase "C" (even if you specifically search for an uppercase "C" in the "Find" box).

jadedrifter16 Newcomer

2 messages
joined Sep 2010

#399 · Mar 23, 2011

Quick question about Excel

I need a formula that pulls data from one specific cell on another sheet. I know how to use something like = Sheet3!C3 to get the job done, but there’s a catch: if I insert a new column, everything shifts. Suddenly, what was in column C moves to column D, and my formula automatically updates to = Sheet3!D3.

Is there a way to lock this down so it always grabs C3, regardless of whether someone decides to shove a new column in between?

Kyle Johnson2 Newcomer

1 message
joined Feb 2015

#400 · Mar 23, 2011

jadedrifter16 said:Is there any way to lock it so it always pulls from C3, even if I start shoving new columns in?

Ever tried using an absolute cell reference like = Sheet3!$C$3
?

Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...)

🔗 Similar threads