The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
0answers
9 views

Knowing if a table is in “native” Word Format

I'm sorry if this is a really dumb question, but I need to submit a document in Microsoft Word format and furthermore all tables must also be in the "native format" (their words). For the tables in my ...
1
vote
1answer
20 views

Unable to format datetime in Excel Table

I have an Excel document with a table linked to a table in sql server containing a datetime field. The datetimes display as yyyy-mm-dd hh:mm:ss.sss and I'm unable to format the cells directly to a ...
0
votes
1answer
17 views

Simplest import of pipe-delimited text w/header to PostgreSQL

I am trying to create a database with several tables. One of the tables is intended to hold about 1.3 million rows of data from the U.S. Economic Census. The data is in a pipe-delimited text file. ...
1
vote
1answer
21 views

View Elements in Word Doc

I've got a word document that uses independent tables to control layout. For example: +=================+ | Table 1 | +=================+ +=================+ | Table 2 | ...
0
votes
2answers
42 views

Making a long table with both repeating column titles AND section titles

At my workplace we make many versions of a 5-7 page document that is basically one long table in Word 2010. The repeating header row lists the type of information in each column. The problem is that ...
1
vote
2answers
55 views

Excel Lookup adds double quotes to string

I'm using this formula to get value form a table =LOOKUP(C11;Alias[A];Alias[B]) where C11 = 12354567 But when I use =LOOKUP(LEFT(C11,7);Alias[A];Alias[B]) where C11 = 12345678, the formula does ...
0
votes
1answer
22 views

How can I have only inner cell spacing? (Remove outer cell spacing)

I have a table in Word 2013 with 0.45cm cell spacing applied to the table: For the purposes of this question, I've turned on some extra borders: How can I remove the "outer" spacing, and just ...
1
vote
0answers
22 views

how to change default table text wrapping in word 2013

Problem I'm trying to create a new table style that has some space between the text right under the table. When I select a single table and go to table properties, I can set the text wrapping to ...
1
vote
3answers
92 views

CHKDSK: What option DOES NOT delete files and turn them into .chk files?

I had a recent power outage while using my computer, with a 1TB hard drive being directly accessed as the power went out. When the power came back on, and I rebooted my computer, one of my 1TB hard ...
0
votes
3answers
54 views

How to use =VLOOKUP under these circumstances?

So I know how to use =VLOOKUP when you are searching for a single value within a cell, but I'm not sure how to do it when I have a range, ex. say the cells value is 1-5, the next is 5-10. This is ...
1
vote
1answer
57 views

Word 2013 - How to create a new table style from an existing table style?

In Word 2013, lets say I have a few table layouts. For example Is there any way to create a new table style via the Design tab based on my existing table design, or am I forced to try to emulate ...
0
votes
1answer
23 views

Spacing before the paragraph right after a table?

I sometimes use Microsoft Word 2010 (and sometimes 2003). My Body Text style has space below, but not above, and I want it to stay that way. Now, when I insert a table between two paragraphs of Body ...
0
votes
1answer
16 views

How to refer to a 'related' table in another excel table?

I have created two related tables (tableA and tableB) in excel and linked them using 'Relationships' in Excel 2013. I'm trying to create a new formula field in tableB that refers to two cells from a ...
0
votes
2answers
39 views

How to autofit table's row height in MS Word?

I want a table to fill a page entirely, firstly I can find an AutoFit Window option to fit the table's column width, where can I auto fit the table's height to do the same? I'm using MS Word 2013.
1
vote
2answers
99 views

How to remove extra space between line of text and table

In Word 2013 I want to be able to have the table flush with the line of text above it. That is I don't want the extra line break. I indicated in red the area I won't removed. How can I do this? ...
0
votes
1answer
25 views

In MS Word, how to prevent orpahned table headers at page bottom?

I'm using MS Word 2010 to write a document. I have a table with a header row (indicated as such, 'Header Rows Repeat'). Now, the table starts pretty low on the page, and Word decides to break it ...
0
votes
3answers
63 views

Import HTML table with CSS to MS Word

I have created a table below using R with HTML code attached at the end of the question. The default output from R fits perfectly my need, but I need table to be shown and editable in MS Word. I ...
0
votes
2answers
18 views

Microsoft Word 2010 Table- Single Page

Trying to keep a table on one page- tried "keep lines together" and "keep with next". Neither works- what am I doing wrong? Should I select the text of the table or the whole table? Tried both, ...
0
votes
1answer
20 views

Excel 2010 - Use a Variable in a structured Table Reference?

I have several tables of financial forecasts (Revenue, Cost, Staff, etc). Each forecast has a unique name (FY14-1, FY14-2, etc.) I would like to use a variable in a structured table reference to get ...
-1
votes
2answers
36 views

How to have “simultaneous columns” in a Word document?

I have a paper form document that I need to convert into a Word document. It features 'side-by-side' text and a bit of an unusual layout. I'm unsure of how I can receate this in Word. Do I have to ...
0
votes
1answer
32 views

Table margin in Microsoft Word 2013

How can I insert margin (top margin in my case) to table in MS Word 2013? The table is located at the top of the first page, but I can't resize the height of the header (because of the other pages) ...
0
votes
1answer
27 views

Access table data by row index

I have a Table in Excel that is laid out as follows. What I require is a way of accessing a table row by index for a calculation. To be precise, I have been asked to work out an overall coefficient ...
0
votes
1answer
20 views

Formula error message when adding new rows to tables in Excel

I always use tables when working with Excel, but recently I’ve run into a strange new issue. I'm assuming it's just a bug and I'll need to reinstall but this issue is on my work system and that will ...
0
votes
1answer
40 views

How to extract everything between <table> and </table> in multiple HTML files

I have been trying to extract this data for a couple of hours without luck. I either want to just extract all the table tags from the HTML and save them to a sperate file or everything between these ...
1
vote
1answer
64 views

Repeated header rows disappear after linked table is updated in Word

I am trying to figure out how to prevent Word from removing the "repeat as header row at the top of each page" option when a linked table is update in Word. I have ~300 linked tables in one document ...
0
votes
1answer
37 views

Windows Routing Table

Consider following routing entries in windows route table: Address Mask Gateway Interface Metric: 0.0.0.0 0.0.0.0 10.0.43.1 10.0.43.6 10 127.0.0.1 ...
1
vote
2answers
27 views

Assistance with table in word

I've got a table within my document that has decided to move right up to the top of a page and for some reason I am unable to move it. I tried the Control, Shift and Enter and all it does is move the ...
2
votes
0answers
88 views

Word 2010 Table stick to top of the page, how to remove it?

Please have a look at this image: I have a table that is 4 pages long. The tableheader is stuck to the top of a page, and then that whole page is empty. The table continues on the next page. How ...
-1
votes
1answer
35 views

Rearranging spreadsheet data

If I have the following data table: Country 1990 2000 2010 LEB 1990 LEB 2000 LEB 2010 Afghanistan 15 17.72 18.24 48.60 54.86 59.61 ... How would I in an automated ...
0
votes
1answer
89 views

Populate empty table with data from oter table based on dropdown list selection

I have 3 tables, Tab1, Tab2 and Tab3 containing data and an empty table Tab The user can select in a drop-down list, option1, option2 and option3. On the selection from user the empty table Tab will ...
0
votes
0answers
96 views

Link table in Destination Workbook to table Source Workbook in Excel

I have two workbooks, which work as follows: The source workbook has a table where the values are inserted or updated; The destination workbook has a table linked to the source table. I came up ...
0
votes
0answers
158 views

“Reference is not valid” error when refreshing pivot table

I have a .xlsm file on a network drive (source.xlsm for example) with a table that serves as the source for pivot tables that live on various other files (localfile.xlsm for this example). When I try ...
0
votes
0answers
24 views

Two default routes with Dynamic IP

I have second connection to the Internet added with a Dynamic IP(VPN). following this guide: http://www.rjsystems.nl/en/2100-adv-routing.php I'm stuck at a point where I need to add: ip route add ...
1
vote
0answers
41 views

Tables from Word 2007 are chopped off in 2013

I'm merging several documents together from various text editors. Some of the tables from Word 2007 don't display correctly in Word 2013, the right side gets cut off. See image below. Any idea why ...
0
votes
0answers
70 views

Excel Combo box to filter a table column

I have a table that I want to filter a column of 'team names' (D10 is the column header) using a combo box (which has a list of the 10 team names from another sheet). So, when I select a different ...
0
votes
0answers
29 views

Select column without cell adjacent in Excel for Mac

I want to select the entire column to the left without the cell adjacent to the left to run a fuzzy-lookup. Of course I'd like to make that expandable, so I don't have to make it by hand. Here is the ...
0
votes
2answers
130 views

Newly inserted rows in a table do not get properly formatted

I am using Excel 2013. I have a table (not just a cell range, but a full table with table name, etc.). I have applied striped formatting to it. When I add new blank rows to the end of the table, they ...
0
votes
1answer
70 views

Unable to sort selected cells within the Table in Excel 2013

I created a Table in Excel 2013 but I want to sort only selected cells. The table range is A1:I200 but I only want to sort A150:I200. I tried selecting the cells, right click, sort, it sorted the ...
0
votes
1answer
123 views

Excel tables: Tag collumn in table

I am really not a power user of Excel, so I hope my question would make sense. I need to use Excel as a "database programme" (even though I know there are other sollutions actually built for that). ...
0
votes
1answer
162 views

Line chart from multiple tables in Excel 2013

I have two sheets, "Graphs" and "Data". In "Graphs" is a line chart with a single line that gets X and Y values from tables in "Data". I want the chart to be updated automatically when I add ...
0
votes
1answer
31 views

Command codes in windows

Here is this article there is a description how to configure a key on Microsoft keyboard. In the article there is a concrete direction what codes assign for specific operations - namely for Next and ...
0
votes
0answers
52 views

Excel or OpenOffice Table Summary: how to reconstruct a table from another, with “missing” values

I have a table of values (partial) with 3 columns: month (from 1 to 12), code and value. E.g., MONTH | CODE | VALUE 1 | aaa | 111 1 | bbb | 222 1 | ccc | 333 2 | aaa | 1111 2 ...
1
vote
1answer
62 views

Word 2010 Macro help - Convert table to fit print layout width

I have a bunch of word docs that I've converted from HTML, which look OK in web layout, but when we switch to print layout, they are chopped off on the right hand side. I have a macro I use to convert ...
1
vote
2answers
199 views

Cumulative average using data from multiple rows in an excel table

I am trying to calculate a cumulative average column on a table I'm making in excel. I use the totals row for the ending cumulative average, but I would like to add a column that gives a cumulative ...
0
votes
2answers
81 views

set hdd flag to boot in linux now mac will not read the exfat filesystem

I was trying to read an exfat file system in linux and removed the original flag of lba.then remembered I had to install exfat-utils. The drive is still exfat but now will not mount to OSx mountain ...
1
vote
0answers
142 views

Make Excel behave like a HTML table editor? [closed]

Is there any way to make an Excel 2010 spreadsheet act like a HTML table (auto wrapping, basic paragraph formatting including blank lines, bulleted lists, etc)? Preferably, one that makes return ...
5
votes
2answers
199 views

How to convert embedded excel sheet to word table?

We receive word documents from clients that will sometime contains Embedded Excel Object(sheet) and we need to convert them to word table so that we can then import the documents in InDesign properly. ...
0
votes
1answer
208 views

Lotus Notes : How to set column width when creating a table in vbscript or javascript?

I tried applying the AppendTable method as described in this article for the IBM Lotus Domino Designer. While i have successfully created the table with fixed width, I cannot manage to pass the array ...
-2
votes
1answer
276 views

Merging data tables to form one master table

I have multiple sheets containing a table each which I want to merge to form a master table sheet. I also need this master sheet to be updated automatically incase we make any changes to the tables ...
1
vote
2answers
1k views

Excel VLOOKUP by second column using table name as range

Using the example table below, I can use the formula =VLOOKUP("ABC123456",Table1,3,FALSE) to lookup the Demand value, but I want to do be able to perform the lookup by using the Cust Part field ...