The tag has no wiki summary.

learn more… | top users | synonyms (1)

10
votes
6answers
25k 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 ...
8
votes
2answers
6k views

How to open several tables in different tabs in SQL Developer

I have several schemes and need to open different tables in different tabs from different schemes at the same time. SQL Developer opens the table view in the same tab. Clicking whilst holding Ctrl ...
8
votes
9answers
12k views

How do I get rid of the extra space in tables with Microsoft Word 2003?

I am copying and pasting tables from another document (Word 2007) over to Word 2003 and when I do this, right click on the upper left hand corner of the table, AutoFit, AutoFit to Contents, I am left ...
6
votes
9answers
74k views

Rotate a table in word

I have a word 2007 document in portrait mode. I have a table that is too wide to fit in 8.5" but would fit in 11". Is there a way to make just one page landscape? Or alternately is there a way to ...
5
votes
2answers
23k 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 ...
5
votes
4answers
7k views

How to set up application-specific routing table on Windows?

Suppose network interface 1 (net1) and 2 (net2) are both connected to the Internet. I want application 1 (app1) to use net1, and application 2 (app2) to use net2. How can it be done under Windows? If ...
5
votes
3answers
2k views

Flickering tables using Office 2002 on Windows 7

We are currently using Office 2002 on Windows XP but will be moving our users to Windows 7 in the next few months. Part of our business is writing research documents so there is heavy use of Word ...
5
votes
2answers
193 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. ...
4
votes
10answers
55k 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 ...
4
votes
3answers
10k views

Excel table - delete rows not in filter

i have a very large table in excel (1000's of rows) and i filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown [ ie dont meet filter conditions]? this would enable ...
4
votes
2answers
2k views

How to paste table from MS Excel to Wolfram Mathematica?

When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica. How to have a ...
4
votes
2answers
6k views

What's the difference between a Table and a Named Range in Excel 2007?

Can someone explain the difference between Tables and Named Ranges in Excel 2007? It seems that in addition to having the features of Named Ranges, they're somehow marked as Tables which gives them ...
4
votes
5answers
5k views

How can I extract text from a table in a PDF file?

I am trying to implement an algorithm described in an academic paper, which I have in PDF format. The algorithm includes a table of 256 entries that I want to copy to my implementation. However, I ...
4
votes
2answers
38k views

How do I set the first value of AutoNumber in Access?

I don't need to reset the AutoNumber value like this question, but rather would like to first set the number to: 1001 Which then increments like normal: 1001 1002 1003 ... ...
4
votes
2answers
473 views

Using Emacs align-regexp to format tables

Vim has the neat Tabular plugin that allows you to quickly align some text. I use it a lot to align blocks of code along a certain character (mostly things like = and =>). But it also does a very ...
4
votes
1answer
3k views

Restricting table cell resizing in Word

Is it possible to restrict users from resizing the cells of a table in protected documents in MS Word 2010? I want to restrict them from making any changes to the layout of the table (or, at least, to ...
3
votes
3answers
8k 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?
3
votes
2answers
6k views

How do I pull data from multiple tables into one table in Access?

I have multiple tables that contain tasks according to their category. Each table represents that category. What I need to do is create a 'Master' table that then is able to pull data from ALL the ...
3
votes
2answers
22k views

How to adjust the thickness of SOME lines in a Word table

I have a table in Word 2010 and would like sets of rows to be distinguished from other sets, but still all be in the same table. So, I would like a thicker grid line between some of the rows. But I ...
3
votes
2answers
1k views

How to efficiently insert a table from R into a Word document?

I am creating a Word document (.docx) using LibreOffice. I need to include some numeric results I calculated in R. They look like a simple table of numbers, with text captions for the rows and ...
3
votes
1answer
916 views

Using the INDIRECT() function with table formats [closed]

My purpose is to create data validation dropdown lists in Excel that reference whole columns in a table-formatted set of data. Ultimately, I hope to create a dynamically changing set of data by which ...
3
votes
1answer
659 views

Interactive console based CSV editor

Although spreadsheet applications for editing CSV files on the console used to be one of the earliest killer applications for personal computers, only few of them and even less documentation about ...
3
votes
1answer
111 views

Excel file links through SharePoint

I'm working for a small company which manages it's knowledge throughout Excel files. Some of the files contain data from other files, for example our orders file contains products that are saved in ...
2
votes
1answer
614 views

Resources about Excel tables and structured references?

I'm new to Excel-post-2000, and I'd like to learn more about how to use tables (formerly lists) and structured references. Can anyone point me to some good treatments of this topic that go beyond the ...
2
votes
1answer
169 views

How to configure the table width inside a landscape page header to be 100%?

I have a Word 2010 document with both portrait and landscape pages. I have a table in the page header, with its width set to 100%. The problem is that on the landscape pages the header table is only ...
2
votes
1answer
1k views

Export Office Excel table to csv using a macro

I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv. My current workflow: 1. Select table manually 2. Copy the contents into a new workbook ...
2
votes
1answer
4k views

How to make a table span two columns?

I am making a two column document, but I have a large table that I want to make span the columns. How can I do this in Microsoft Word? ................................ TABLE ...
2
votes
1answer
163 views

Combining more than 10 tables data in to one table

In Excel 2003 I was able to combine more than 10 tables' data in one pivot table through "Multiple Consolidation Range". However I couldn't seem to find the same option to do it in Excel 2007. Any ...
2
votes
1answer
653 views

Multiple tables in Microsoft Access that need to feed into one table

In my Access (2010) database, I have 4 linked tables (from other Access databases) that I would like to feed into one table, or query. I've tried using the query design but can't seem to get it right. ...
2
votes
5answers
5k views

MS Word to PDF. Corrupted tables borders

I´m having problems while saving a MS Word document (.doc OR .docx) to PDF (by saving it directly as PDF from MS Word, printing it with the Adobe printer, etc) on how the tables borders are displayed. ...
2
votes
1answer
636 views

Copy Word table and make it default in Word

I have a nice custom table design in Word 2010. I wish to allow my colleagues to use this table design as their default table template for Word and Outlook. In my own test, it would magically appear ...
2
votes
5answers
3k views

How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?

Consider a table of employee name, age and employee manager. Employee manager is a reference to employee name in same table but different row. I tried this by referencing cell =A3 Now if I sort ...
2
votes
1answer
1k views

How do I move a table structure down in written documents?

I often run into this issue: I have a table (as in data in a table format) and the table is at the start of a document or email. I wish to move the table down the page but my cursor will only move to ...
2
votes
1answer
3k views

Free OCR Software that Detects Tables? [closed]

Im wondering if anyone knows if any free/open source OCR software (hopefully even anything command line or coding based) that can detect and reproduce data tables in digital form? This stems from ...
2
votes
1answer
648 views

Exporting a subset of an Excel sheet as a (clean) HTML tab

I have an Excel sheet with several sheets and containing quite a few tables of information which are really intended to be published on a common wiki at my company. Previously, we used to use ...
2
votes
0answers
87 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 ...
2
votes
0answers
78 views

MS Word - Hidden Table Re-appears After Save, Close, Open

I have a Word document with a table at the top of the first page that I want to hide by default (it contains maintenance information and notes that doesn't always need to be shown). If I select the ...
2
votes
0answers
74 views

Microsoft Access 2010 - error when validating formula

I am trying to create a field to convert currencies from one of 2 fields, thus I am putting the following code in "Default Value" as I want this field to be open for my manual input too: =iif([£ ...
2
votes
2answers
83 views

Creating A Log Of Files In A Folder

I am an absolute newbie in this thing. Can anyone help me to build a table that lists all files in a specified folder so whenever a file is copied to that folder the table should update. I need the ...
2
votes
1answer
23 views

Enabling the User to Insert the Data in Access Database

I have created a data model in Access Database. Tables that are composite parts of the model are loaded with data. Some of the data needs to be loaded manually. Now I would like to link couple of ...
2
votes
1answer
584 views

How can I prevent a table within a list from continuing the numbering scheme?

I'm writing a list of steps for some documentation, and want a simple table to show some settings based on conditions. The problem is that Word is adding a number to each cell in the table, when the ...
2
votes
2answers
2k views

Excel: lock sheet, but keep tables expandable

My goal is to protect a sheet, but make users able to edit and add rows to the contained tables. When I try to protect the sheet with no cells locked, the tables become unable to add rows even though ...
2
votes
2answers
867 views

How can I create a custom OpenOffice / LibreOffice Writer table AutoFormat scheme?

None of the basic table AutoFormat schemes in LibreOffice Writer have both an alternation style defined and no sum column/row style defined. If they have alternation, they always seem to have sums. ...
1
vote
5answers
3k 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 ...
1
vote
2answers
53 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 ...
1
vote
2answers
86 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? ...
1
vote
3answers
3k views

Excel 2010: How can I obtain a one-to-many rows table by merging duplicated cells in a large normalized table?

As I am a newbie when it comes to Excel (and the entire Microsoft Office suite, to be honest), I spent a lot of time browsing for a solution to this issue - how to get a one-to-many rows table out of ...
1
vote
2answers
1k views

How do I group rows in a table by one column's value in Excel?

I have a table of data (5000+ rows) with two columns, ID and value. It may look like this: ID Value 01 02 01 03 01 17 02 05 03 06 03 28 What I want to do is find the average value for each ID. ...
1
vote
3answers
548 views

Import table from a image to a spreadsheet

How can I import a table from a scanned image (jpg/pdf) file to a spreadsheet? Example scan is here
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 ...