CheckEmoji Community · the emoji forum
🏠 Home 🆕 What's new ❓ Unanswered 🔥 Popular 📡 RSS Members 👥 0 online
log in · register
Home › IT › Software › Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...)

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

Started by Sophia Newman6 · · 👁 51 views · 1.6K replies

📡 Subscribe to replies

Participants Sophia Newman6Mark ReedDrew Hall3silverfox91hiddennomad13Kimberly Miller6Drew GarciaGeorge Nguyen3Walter Jackson48Kyle Johnson2neongull3slyhound32Benjamin Wilson7Edward Foster23northerncanyon16boldwalker2ruggedpanther2rustyranger12Jesse Williams14Hannah BarnesTerry Hayes2Robin White7driftingbear98Brenda Turner94 …
Steven Wright18 Steven Wright18 Newcomer
8 messages
joined Nov 2013
#1081 ·
So, here’s the deal:

How do I keep row 1 visible on my screen at all times, even when I'm scrolling way down?

That row holds my column headers where I enter everything, and once I scroll a few pages down, I lose track of which column is which. It's a bit of a headache.

Thanks
electricdriver93 electricdriver93 Member
24 messages
joined Aug 2007
#1082 ·
Steven Wright18 said:So the question is:

How can I keep, say, row 1 visible on my screen at all times, regardless of how far I scroll down?

Basically, that row contains my column headers where I enter data, and once I scroll down a few pages, I lose track of which column is which...

Thanks

Select the row directly below the one you want to stay visible; then head over to the Window menu and select Freeze Panes—that’s how it works in the 2003 version. It should be something similar in the newer versions as well.
Steven Wright18 Steven Wright18 Newcomer
8 messages
joined Nov 2013
#1083 ·
electricdriver93 said:Just highlight the row right above the one you want to stay put, then head over to the Window menu and select Freeze Panes—that's how it works in the 2003 version, though I assume it’s pretty much the same in the newer ones.

Yeah, I'm running the 2003 version. Thanks a lot, turns out it was way too simple. 😁
Kimberly Campbell5 Kimberly Campbell5 Newcomer
7 messages
joined Dec 2011
#1084 ·
I was wondering if there’s any specific software out there that can help me strip the protection off an Excel file when the document is locked
Kate Foster12 Kate Foster12 Active Member
92 messages
joined Feb 2011
#1085 ·
I'm working in Word 2007 using Equation—trying to create an arrow with two numbers stacked vertically underneath it. Any idea how to pull that off? 🙂

There aren't any fractions involved or anything... just two separate numbers sitting one above the other under the arrow. 😁
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#1086 ·
Kate Foster12 said:I'm messing around in Word 2007 using Equation and I need to make an arrow with two numbers stacked right under it.

There you go. Grab the file HERE
Kate Foster12 Kate Foster12 Active Member
92 messages
joined Feb 2011
#1087 ·
Just set it up with an up arrow and a down arrow. 😁
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#1088 ·
Arthur Ramirez20 said:Anyone know a way to strip protection off an Excel file when the document is locked?

Get creative. Don't just stare at the screen waiting for magic—use your head. Google is your friend. 😉
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#1089 ·
Kate Foster12 said:Just build it with an up arrow and a down arrow. 😁

Why don't you put in some actual work yourself? Look before you go calling me "cheap"
Kate Foster12 Kate Foster12 Active Member
92 messages
joined Feb 2011
#1090 ·
It would have been nice if you actually explained the process—that’s what I was asking for in the first place. Whatever, thanks. 🙂
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#1091 ·
Kate Foster12 said:I mean, it’d be great if you could actually walk me through how to do it, which is what I was asking for. But whatever, thanks anyway. 🙂

Just check out some tutorials

- Equation in Word
Kate Foster12 Kate Foster12 Active Member
92 messages
joined Feb 2011
#1092 ·
Thanks, but this still isn't hitting the mark. Those tutorials don't cover what I'm actually looking for—plus, you misunderstood my point about the arrow needing to be positioned above the number rather than beside it.
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#1093 ·
Kate Foster12 said:Thanks, but that’s still not what I'm looking for. Those tutorials don't cover what I need, and you totally missed the point—the arrow should be above the number, not off to the side.

So I read this bit
under that shared arrow
Just do it with an up arrow and a down arrow

From that, I figured everything just stacks vertically.

The tutorial covers the basics; it was up to you to dig out the specific setting to get the result. Here's a screenshot

image

image

Just click the input field and type the number. Then move over and pick the arrow from the Basic Math menu.

Here's the file

hope that clears things up for you 😉
later
Kate Foster12 Kate Foster12 Active Member
92 messages
joined Feb 2011
#1094 ·
I finally get it now! Thanks a million! 🙏
redmoose20 redmoose20 Newcomer
1 message
joined Sep 2010
#1095 ·
Could someone please lend me a hand?

I am currently struggling with numbering equations in Word, specifically trying to link them to a cross-reference.
The issue is that whenever I follow the standard procedure—going to Word 2007 = > References = > Insert Caption = for each individual equation, and then later attempting to call that equation back into the body of my text using Insert = > Cross-reference = for an equation—the software insists on displaying both the actual equation and its number together. What I actually need is just the number itself, standing alone in the text.
I did consider using bookmarks, but honestly, that sounds like a total nightmare given that I’m dealing with upwards of 200 different
entries. I even attempted to create a custom caption where the label was nothing but a blank space, but predictably, that didn't work at all. Does anyone have any clever suggestions? I am open to anything except installing some specialized math software, as my higher-ups—who I can only describe as a force of nature beyond my control—have strictly forbidden it.
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#1096 ·
redmoose20 said:tried making a custom caption called just "blank" but it didn't work. anyone got ideas? anything except installing some math software because my boss won't let me touch that stuff.

Best bet is putting your Equation inside a table.
Go to insert New label and make a new group—call it something like "My Equations."
In Word 2007 => References => Insert Caption => check the box for Exclude label from Caption so the text part gets ignored.
Now you've just got the number without the "My Equations" label. Do that for all your equations.
When you want to drop an Equation number into your text, just hit Insert => Cross-reference => and under Reference type pick "My Equations" to see all the numbers in that group. For "Insert reference," grab Entire Caption.
Just make sure you click the specific number you're linking to.

Here's the file HERE
redmoose20 redmoose20 Newcomer
1 message
joined Sep 2010
#1097 ·
Kyle Johnson2;35528486 said:

Is this some sort of recurring nightmare???????

The standard protocol—the one we’ve all been conditioned to follow—is that the equations and their corresponding numbers should reside on the very same line
But now, having the audacity to place my equations inside tables (I’m assuming a simple 1x1 setup here), I find myself completely thwarted; I simply cannot insert a cross-reference on that same line, only on the one following it.
Does anyone out there possess a solution to this particular headache, or am I destined to struggle with this indefinitely?
Kyle Johnson2 Kyle Johnson2 Newcomer
1 message
joined Feb 2015
#1098 ·
redmoose20 said:Standard practice is to keep the equations and their numbers on the exact same line.
Now that I'm putting my equations inside tables (thinking 1x1), I can't insert a cross-reference on that same line—it just forces me into the next one.
Anyone got a workaround for this?

You could try making a 1x2 table. If the number starts drifting outside the cell, just shove it into the right-hand column.

btw: check out this tutorial Equation and Cross-reference in Word 2007
redmoose20 redmoose20 Newcomer
1 message
joined Sep 2010
#1099 ·
Kyle Johnson2 said:You could always just whip up a quick 1x2 table; if your number starts bleeding over the margins, just shove it right into that second cell on the right.

Anyway, you might find this useful: check out this tutorial on my equation and Cross-reference in Word 2007


Thank you, thank you, thank you—that actually saved my skin more than I can say.
And thanks for the tutorial too, much appreciated.
Gerald Young25 Gerald Young25 Newcomer
6 messages
joined Aug 2011
#1100 ·
Gerald Young25 said:I managed to pull it off using that new example you shared.
Everything is running perfectly now. Thanks for the help...
👍

http://www.microsoft.com/en-us/office/excel200...working-hours.html

Kyle Johnson2, which conversion formula should I use when dealing with time formatted like this:

2d 12h 52min

The formula you provided works fine until we hit the 10-hour mark (xH), but once it exceeds 10, it fails...

Thanks in advance.

You must log in or register to reply here.

Log in Register

🔗 Similar threads