Posts by Kyle Johnson2

Daniel Thomas70 said:So after I insert a new row above the first one with 3 units, cell F10 (which is now F11) doesn't show the right total? Like, instead of showing 2, F11 should actually be showing 5, right?

Try this based on your first screenshot:

Put this formula in cell F10: =COUNTIF(INDIRECT(G10):C2;1)
In cell G10, just type: A1

Now, whenever you drop in a new row, the formula will always count starting from cell A1.

Sam Peterson6 said:So, here's the deal—does Word 2007 have a way to catch my typos when I'm typing in English?
Like, if I mess up and type "Yu mast be loged," will it suggest "You must be logged" instead?

Check out these links, might help you out

- Word 2007 Spell Check set up
- Check spelling and grammar in another language
- Online English spell check
- learning English language
- Enable The Use of other languages in Your Office programs

Kyle Davis6 said:I've got two Excel files, ..................Wondering how I can link them together without having to open the price list and manually overwrite everything.

Like @Karl said, just use the VLOOKUP Excel function and check out this link while you sip your coffee

- How to link data between two Excel files

rustywalker1 said:but I'm actually asking about when you've already formatted it to show a specific number of decimals after the dot.

Excel Advanced Options
Excel Options => Advanced => Automatically insert a decimal point

Excel 2003
Tools => Options => Editor tab => Fixed Decimal places

Sarah Campbell16 said:hey guys,
can someone please help me out? I've been struggling with this for days

When you're working on writing a thesis, you gotta be careful about which styles you use for headings and subheadings. You'll need them later to generate a table of contents. If you've made way too many sections and want to scrap them, just follow the steps in that tutorial using Find / Replace, or just switch over to Outline view and delete them one by one manually

- how to delete all sections at once in Word

If you want a heading without a number, just tweak the style for that heading (Heading 1). Check out image 19 in the tutorial, but make sure you Select All instances of that specific style first (see image 18, Select All ?? Instances)

- Changing styles in Word and turn off the numbers for that style (use the Numbering option, see image 20)

If the interface is tripping you up because it's in a different language, check out the English version here.

- Headings and subheadings in Word

Bryan Chase9 said:Can Word Office 2010 open files from Word 2002? And vice versa... I know you have to save them differently, but just asking.

Why wouldn't it work? As long as your Word isn't broken, it should be able to load old docs or save them down for older versions. Check the second screenshot in the tutorial. You just gotta pick the 'Word 97 - 2003 Document' option

Matthew Garcia4 said:help me out with an Excel chart if anyone can

here go ahead and mess around with this 🙂

Sandra Wells12 said:Thanks for trying, but it's just not doing it... I need it to scan the whole damn sheet for errors, especially where people are typing stuff in... plus, it doesn't actually take me to the cells where the mistakes are...

Give this a shot

Code:

Sandra Wells12 said:The issue is I can find and recognize code, but I can't actually write it. Can anyone help me out?

Honestly, I'm not much of a coder myself either. 🙂

Give this a shot and let me know if it fails—we'll try something else.
It's a simpler way using one single VBA script. Just make sure you update the "Sheet1" name.
Copy this VBA into the Sheet module
Code:

Sandra Wells12 said:Sub Spell_Check()
ActiveSheet.Unprotect Password:="password"
Cells.CheckSpelling SpellLang:=1033
call ProceduraZaOznacavanje
ActiveSheet.Protect Password:="password", DrawingObjects:=True, _
Contents:=True, Scenarios:=True

End Sub

Looks like someone else is dealing with the exact same thing. You're gonna need to add a procedure to highlight those cells or text.

electricmarlin18 said:I want them numbered on the right side (only for landscape pages) since this is for a formal record that'll be bound—page numbers need to be visible when flipping through the doc.

Just go to Insert page number within the margins.

driftingpilot8 said:How do you set Excel to default all number cells to the 1,000.00 format? I need commas for thousands and two decimal places every single time.

Open a blank Workbook.
2. Select it. All cells.
Right-click and hit Format Cells. Set it up. Formatting numbers. Just use a decimal point and a thousands separator. You can even toss in a US Dollar ($) sign if you feel like it.
Just Save Workbook under a specific name, but set it as a Template.
Next time you’re messing around with cash values, just pull up that Template. You can even set a shortcut key on your desktop to make it faster.
6. Every single time you punch in a number, it’ll snap right into the format you want. Boom. Done.

driftingpilot8 said:Still haven't figured out what that thing is or how it even moves.

No point in preaching to the choir here. We already know what's up. Just Google it. Pick one from this list:

Just grab the text, hit Home > Paragraph > Shading, and pick "No Color." Done.
-----------------------
Open Word 2007. Hit File, then Word Options. Go to Advanced, find that Cut, Copy, and Paste section, and just flip the 'Pasting from other programs' setting to 'Keep Text Only.' Simple as that.
------------------------
If you're using Word 2007, just hit the Office button, go into Word Options, then Advanced. Look for the Cut, Copy, and Paste section, find the dropdown for 'Pasting from other programs,' and set it to 'Keep Text Only.' Done.
------------------------
Just hit that "Clear All Formatting" button on the Home tab. Easy peasy. Enjoy!
---------------------
Just dump that text into a text editor—like Notepad. It’ll strip out all those weird formatting glitches and messy code instantly.
----------------------
Just right-click before you paste and hit "Paste as Plain Text." That should fix it.

wiredwolf34 said:Alright, let's see which one actually works. Cheers!

Give it another shot. Try this. How to make a Pivot Chart from multiple datasets. Just make sure you go with the other option—the Pivot Chart.
Mess around with the settings for a bit and do some digging while you're at it. YouTubeI think the issue is you're stuck on wanting a line chart, but honestly, a bar chart might do the job just fine. Check this out. Video tutorial.It pulls data from several different sheets, so you could totally apply that to what you're dealing with. It’d let you pull both the years and those A and B labels right onto the X axis.

wiredwolf34 said:the X-axis isn't showing the full range of data (everything's just crammed on the left side)

Duh. Of course everything's bunched up if you've got Roman numerals for months showing up for just one year, but you selected rows covering multiple years.
Something's not adding up with what you're asking for. How exactly are you planning to squeeze all that data from two different tables onto a single chart?

I reckon you could show two tables for a single year, making the line track the months for both A and B

Or just plot all the years on one chart for a single table (check the attachment))

wanderingranger19 said:when I click it during the presentation, the audio works but the picture is totally gone,

Not much to go on here. Which version of PowerPoint are you using? What's the workflow? On my end, *.avi files play just fine in a slideshow. I'm running PowerPoint 2007 with all the regular updates installed.
Check out these instructions for PowerPoint 2003

- Inserting movies and animated GIF files into a presentation

Just read through the tutorial and follow the steps.

If you're rocking a base install of PowerPoint 2007 without any updates, try this:

1. Before you even insert the AVI file, just rename the extension from AVI to MPG or WMV.
2. Import the video into the slide and see if that fixes it.
3. If it’s still acting up, upload that AVI file along with one of your slides so we can try building a dummy presentation to test it out.

(Don't actually convert the AVI file—just rename the extension.)

Betty Martin15 said:How do I set up/install an American spell checker in my English version of Word?

Didn't say which version of Word you're using. If it's Word 2003, check this tutorial

- Grammar checking in Word 2003

If you're on a different version, just hit one of these links

Nicholas Wells74 said:How do I auto-fill a column with sequential numbers in American Excel 2003?

Check out this tutorial link

- Quickly filling number sequences in Excel

restlessheron19 said:Yeah, Google... found some similar code online without any pop-ups... still don't get why I'm getting an error though?

Look, you gotta actually read the tutorial and know a bit of English. If you don't, just use Google Translate.
Code:

Check out this video How to record a VBA macro in Excel—hit the 0:36 mark to see the blue "Developer Macro Settings" section and the "Trust access to the VBA project object model" option right under it. Toggle that on. Or just look at this screenshot from the tutorial How to enable macros in Excel and pay attention to the checkbox marked with red text saying "this is risky to enable." To get that specific VBA macro working, you need to check that box.

restlessheron19 said:Is it actually possible to use a button (running some VBA code) on an Excel sheet to...delete a Module or Modules...inside the Visual Basic Editor...of that same file?

Google works wonders
Deleting VBA modules via a VBA button

mellowbear21 said:thanks for the help, guys. ended up just reverting to the original Excel sheet and handled it myself using sorting and filters.

Not sure how you were tackling this, but here’s a quick tutorial on how to actually fix it.

- How to pull unique values, count them, and sort

mellowbear21 said:here's the doc at this link

Just like I thought. Don't have the time to do your "homework" for you right now. Check out these links, follow the steps, and then upload the file back for download so we can see what you actually did.

The first example uses text while the second one deals with numbers. Just a heads-up: in Excel, certain formulas only play nice with numbers, not text—or vice versa—depending on what you're trying to pull off. Like the other guy said, what’s the point of these random numbers? What are you even trying to achieve?
I don't get the end goal here, but you haven't framed the task right, nor are you heading in the right direction. If this is about Powerball statistics, check out this tutorial; there's a downloadable file in there with an example of repeating numbers. If not, try this:

First, test this out using an example where you have numbers in column A from A2:A40.
1. Copy the Unique (or extract unique values) numbers from column A over to, say, column D.
2. In column E, use the COUNTIF function to count how many times each value from column D shows up in column A.
3. Record your macro so that it copies columns D and E and performs a Paste special => Value => into columns H and I. Then, select columns H and I and perform a Custom sort by column I, set to Ascending or 'Small to Large'. For the macro, you can create a button and link it to the macro—just make sure to expand the range to match however many rows are in your base table.

You can wrap all of this into a single macro recording.