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 ...
1
vote
1answer
81 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 ...
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 ...
1
vote
3answers
178 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 ...
6
votes
3answers
29k views

How do I insert text above a table at the top of a Word document?

This seems like it should be so basic, but it apparently isn't very intuitive. The scenario: (1) I've inserted a table into a new blank MS-Word document. (2) I want to add some text outside and ...
0
votes
1answer
2k views

Can't type text into table cell when form is protected in Word 2002

I created several tables in an Word 2002 document to act as a form for users to fill out. In some cells I added check boxes and dropdown lists for people to select options from. When I click on the ...
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
4answers
7k views

How can I copy/paste the *formatting* of a table in Powerpoint?

I'm wondering if there's a feature in ppt 2010 to paste the formatting of one table onto another (e.g. table borders, cell background colour). I've tried all the paste specials but nothing seems to ...
0
votes
3answers
2k views

Fixing corrupt files or corrupt file table on a USB drive?

I was doing a virus scan on an external USB drive while copying data over to it. While AVG was scanning my system got locked up I think due to the USB drive running out of space and it required a ...
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 ...
4
votes
10answers
65k views

How to properly merge two tables in MS Word

I would like to merge 2 tables together in Microsoft Word. I have attempted to do the usual drag and drop, but I'm out of luck! I don't know if my mouse is the problem, but even if I use the touch ...
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
40 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 ...
3
votes
3answers
9k views

Is there a way to change background color for a table in onenote?

In word or excel or power point you can change the background color of a table or selected rows or columns of a table, but I can't find a way to do this is onenote. Is there a way to do this?
0
votes
3answers
479 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
3answers
4k views

How to use excel to disply a list of cells, depending on dropdown box selection

What I want to achieve: select list A, B or C from a dropdown, when pressed, list of values displays underneath. I would also like the list to be populated from items in a table (which would have ...
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 ...
12
votes
7answers
28k views

Table Formatting in Excel 2007: How do I remove it?

I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it ...
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 ...
0
votes
2answers
163 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
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
125 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 | ...
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
1answer
330 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 ...
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 ...
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
3answers
14k views

How can I copy tables between word documents without having the format change?

I have two both word 2007 documents, A and B. I want to copy a table from A to B, and that table's format is totally the same as I see in A, not automatically changing the format to B's template ...
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
257 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.
0
votes
3answers
232 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 ...
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
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) ...
1
vote
1answer
480 views

Is there a way to convert a memo field to a text field in Access 2010 in an expression?

I have two tables (each in an Access DB) -- called LinkedTable1 and LinkedTable2 linked to my working Access database. I got them on my computer after downloading them from a SharePoint site (Actions ...
5
votes
2answers
398 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. ...
1
vote
5answers
4k views

Excel 2007: “Format as Table” Increments Column Names

I love using the formatting styles for tables in Excel 2007, but in my data I'm using the same column name for multiple columns. When I format my table using the pre-defined styles, it automatically ...
0
votes
2answers
1k views

How to line up text beside a table's row separators?

this is driving me mad: I need to write text that lines up like this
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 ...