DO NOT USE THIS TAG!

learn more… | top users | synonyms (1)

2
votes
1answer
48 views

how to generate all possible 3 digit combination of the numbers 0-6

This may sound dull to experts and excel pros.. i am in desperate need for help please i am using excel and am trying to generate a table (3 columns) that presents all possible combinations of the ...
0
votes
0answers
9 views

mysql flush tables with read lock verification

this seems like a dumb question and perhaps I'm not googling this correctly but I'm trying to figure out what the table status or database status should show after i issue flush tables with read ...
0
votes
1answer
47 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
0
votes
0answers
18 views

Preserving table borders and shades while converting to text in word 2010

I am trying to create a word 2010 template to display some data to user when he creates a new document based on it. As such, I need to display a table in the document. I have created the document ...
1
vote
0answers
22 views

Excel Table function

I got a Excel file. There is a formula, {=TABLE(C7,C5)}. I cannot find any table name from ribbon Name Manager, so I think there is no table. Then what is this formula doing ?
1
vote
1answer
45 views

Controlling decimal places in Microsoft Word

I am working with loads of tables in Microsoft Word 2010. I would like to limit the numbers I have to three decimals places, along with rounding them. For example: 0.1234 will become 0.123 and ...
0
votes
0answers
14 views

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

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
9 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
58 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
25 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
52 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
62 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
25 views

how to delete taggregate_temp_ tables at once?

In MySQL, I have multiple tables named like this: taggregate_temp_1364792160 taggregate_temp_1364795760 taggregate_temp_1364799360 taggregate_temp_1364802960 taggregate_temp_1364806560 ...
0
votes
1answer
35 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
32 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
24 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
16 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
41 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
367 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
44 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
346 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
215 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
77 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
81 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
217 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
85 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
646 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
200 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
2answers
679 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
5k 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
134 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 ...
1
vote
3answers
498 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
32 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
45 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
70 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
31 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
50 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 ...
1
vote
1answer
188 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
64 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
38 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
361 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
44 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
812 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
152 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
289 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
27 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
74 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
115 views

Excel Combo box to filter a table column

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). When I select a team from the combo box, I want the ...
0
votes
0answers
34 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
1k 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 ...