Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 365: I'm new to Tables - Configuring Font & "Get Data from Table/Range" 2

Status
Not open for further replies.

ladyck3

Technical User
Jan 3, 2003
800
US
I am new to using the Insert > Tables option to my spreadsheets. WHAT A BLESSING (Skip [smile]), but I'm having a nagging issue.

I have the default font under OPTIONS in the app to use "Tahoma 8" and my table is perfect in that regard, UNTIL, I enter new data to create a hyperlink. When I go to an empty cell, right click and select LINK, then enter the word LINK in the "Text to display" field, and paste the URL into the "Address" field, then hit return it happens. The font turns to "Arial 10" and I have to always highlight and change it to the default font.

What am I doing wrong? In trying to discover a solution without having to ask you fine people, I dug around but found no such ability to alter or "make static" a font. I started by trying to create a new table looking for an option to select a font in a Theme or color selection but found nothing on Fonts. Finding this option however, brought up a new question, I wanted to use a color not shown but there was no option to select a custom color, is that possible?

One more thing, when right clicking my newfound tool TABLE, if I right click anywhere in the table, there is an option to "Get Data from Table/Range... on the menu. I selected it, it opens up a query page but what is it? I didn't want to mess with it in fear it would totally fry my data so I ask... how/why does on utilize this option, or what is the purpose?

Thanks in advance,
Laurie
 
Hyperlink has its own style. It is applied when hyperlink is inserted.
To edit the style, expand the 'cell styles' button ('styles' section in 'home' tab). Right-click the hyperlink style and select 'modify' in the popup menu. Next format it according to your needs.

combo
 
Laurie,

I really could not help you with hyperlinks. But I'm gung ho on Structured Tables. And I just had an incident with one of my own that I'll briefly share. My wife and I are a new diet and I decided to track our carbs and sodium. So I made a table of food elements we regularly eat, using the Nutrition Facts on the packages. I had formulas in several columns that weren't propagating to new lines as I added additional food elements. What's that about!!!

Well I Googled and found this

Microsoft said:
...
Use the following rules for table names:
...
Don’t use a space to separate words

I fixed my table headers and VOLA, Y'ALL, i got my formulas to automatically appear on new table rows!

So check out that link. It will help your BLESSING multiply. Then you can...
count your blessings/name them one by one.

Regarding your other question about "Get Data from Table/Range" there are ways, in Excel, of acquiring data for your applications, and Power Query is one of them. Combo and others here, are much better versed on this feature. I use older methods that don't have the bells and whistles that Power Query does. Data acquisition is a whole nuther tool.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!
 
ladyck3 said:
One more thing, when right clicking my newfound tool TABLE, if I right click anywhere in the table, there is an option to "Get Data from Table/Range... on the menu. I selected it, it opens up a query page but what is it?
Excel opens built-in Power Query editor. Power Query is one of MS business inteligence tools, now it may be found in Excel and Power BI. It is used to process data in sequential transformations (however, in advanced appications not only sequential, Power Query uses its own M language not only for handling single steps).

Power Query in Excel can get the data from workbook if they are in tables or named ranges. The option 'Get Data from Table/Range' is available for any excel range, it will pick data for processing. After processing data in Power Query environment, the result is returned to table (in new or existing sheet) or will stay as definition only. Output data can be deleted, queries can be removed either in the query editor or after displaying queries (Excel side pane in my Excel 2016).

combo
 
combo:

Response #1: Regarding hyperlinks, I found the part you spoke of, I think, and it was set to Arial 10 [SURPRISE} LOL! I changed it to Tahoma 8, and saved it, the title was style1 and I didn't change it, maybe I should have named it links or something but whatever, it didn't change. But I think the problem is the thing between the chair and the keyboard.. (ME) :) and I'll work on it.

Response #2: Regarding 'whatever it was you said' I'm ... HUH? I think this is totally not something i need, because its so far over my head in my current "Hot-Texas" location with no A/C, have to wait til next Wednesday... I think I'll just leave that little/large thing alone. If it blows my mind, its WAY more than I need.

Skip:

WOW what a find... I am sure that this will come up in my new-found love of Tables and will add this resource to my OneNote Excel data to have on all platforms no matter what I'm doing ... WOO HOO. I learned something on my VERY OWN, you'll be so proud. LOL I did to tabs, one with Resource Data Analysis and another with Type Data Analysis and after adding years 1991, 1997 and 2001 to current (I have older patterns from 1915 and 1930 but obtained those for free so no total dollar amounts.. so I just didn't go there. ALL of my totals EVERWHERE matched the total on the main Inventory Sheet and I was SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO HAPPY!

Then, on the 6th, I took a look after adding some data and I was presented with VALUE# VALUE# VALUE# on EVERYTHING and I about died, OH NO. So I started thinking and checking and searching and guess what? I had a "word" in the Dollar column, intead of just a $0.00 which was required for that one particular cell and VOILA!!! BINGO BANGO. I sighed, saved and shut down. After so much searching I figured I'd leave it be for awhile. I save my workbook multiple times a day with date and time, for instance right now its (20230707_6.52p) July 7, 2023 @ 6:52 pm. So I went back like, about 36 hours to where its correct, searched my additions by date and added them back to the correct workbook. Then, however, I was off by $6.27 on ONE of the data analysis sheets and freaked. I honestly don't remember what the problem was but its all okie dokie now.

combo, you have helped me in the past when I was working (over a decade ago) and have always been a real resource to depend on, and I appreciate you... and thank you! I'm not dismissing you in any way shape or form, just that this Query stuff is SO beyond me and I lean on the "old dog/new tricks" statement :) I no longer do business anything, I do Excel as my pleasure.

Skip, you have tolerated my craziness and such, so many years... you are so appreciated but I think you know that.

All I can say you are very find humans and I'm glad I "know" you. There was another, xlm? I forget, but this resource and you guys are just great.

I'm saving that article, Skip! :)

Stay cool guys, its HOT out there (and IN HERE) :)
Laurie

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top