The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
1answer
16 views

Word 2003/2010 extra heigh row height uneditable.

I'm copying word tables from one Word document to another Word document. I would prefer to use Excel but these MUST be in word. The original tables were all formatted correctly with the row height ...
0
votes
1answer
23 views

How to join neighbor cells in Excel

I have some data which I recorded in a bad way, see the picture : Now can I format this into something like this : Error 1 Error 2 (3.2 ± 1.97) E-04 (3.7 ± 1.3) E-03 (2.2 ± ...
0
votes
0answers
12 views

In Access, how can I reset the AutoNumber field as new data is deleted/appended?

Essentially what I have is a temporary table which logs data through an append query. This table is used to store consecutive strings of data, that will be exported to a .csv eventually. What I'm ...
0
votes
0answers
7 views

Removing hidden table formatting from Word

How do I remove the hidden table format that I imported into my document by copy-pasting from internet. There are no visible lines but it interferes with being able to select things individually (I ...
2
votes
1answer
16 views

Text in a table disappears before wrapping

Windows Vista Home Premium with Microsoft Office 2010. I have a table in Microsoft Word where the row size is not specified, but the columns are fixed. When I type text that should wrap, it instead ...
0
votes
0answers
8 views

Coloring a row in OneNote

I saw the thread regarding coloring a table row in OneNote, and as I was trying to do the exact same thing to no avail, I Googled my way to superuser. I found out that there's no way to color a row ...
0
votes
1answer
28 views

How use Excel formula to add new row in table?

I'm using Excel 2013 on a Microsoft Surface 2 (which is an RT ARM machine). It's my understanding that the Surface 2/RT version of Office does not allow scripting or forms. I'm trying to create a ...
0
votes
1answer
23 views

How to plot an R table in Linux terminal

I have a text file that I converted into a numeric vector: numbers <- scan("list_of_numbers.txt") I then put it into a table: t <- table(numbers) Which outputs like this: 1 2 ...
0
votes
1answer
19 views

how to delete taggregate_temp_ tables at once?

In my SQL I have multi tables like: taggregate_temp_1364792160 taggregate_temp_1364795760 taggregate_temp_1364799360 taggregate_temp_1364802960 taggregate_temp_1364806560 taggregate_temp_1364810160 ...
0
votes
1answer
31 views

Automatically remove white space in parenthesis and set number of digits in Word table

I´m exporting tables from a statistics program but I am left with a table where there is white space inside the parenthesis. I´d also like to set the number of digits after the decimal point. Is there ...
0
votes
0answers
30 views

Excel dates with standard format (*) become custom when opened in another country

Here in the USA, I have created an Excel 2007 spreadsheet with a table that contains several columns with dates. I have formatted the date columns using the standard short date format (with the ...
0
votes
0answers
21 views

How to treat MS:Word tables in pre-press for a book?

I am putting graphics such as EMF and JPG into an MS:Word file for pre-press to print a book by offset, in black & white. But how do I deal with the ordinary tables in MS:Word? I intend to change ...
0
votes
0answers
14 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
32 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
127 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
36 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
165 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
128 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
49 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
46 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
179 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
75 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
332 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
73 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
23 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
258 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
2k 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
63 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
234 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
27 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
34 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 ...
0
votes
1answer
49 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
29 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
36 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
52 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
124 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
54 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
29 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
231 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
39 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
351 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
122 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
229 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
25 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
60 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
97 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
32 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
3answers
484 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
119 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
224 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). ...